DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_API

Line 1342: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1338: x_errorcode => l_errorcode,
1339: x_msg_count => l_msg_count,
1340: x_msg_data => l_msg_data
1341: );
1342: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1343: error_handler.get_message_list(l_error_msg_tbl);
1344: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
1345: l_msg_count := l_error_msg_tbl.FIRST;
1346: WHILE l_msg_count IS NOT NULL

Line 3677: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3673: x_errorcode => l_errorcode,
3674: x_msg_count => l_msg_count,
3675: x_msg_data => l_msg_data
3676: );
3677: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3678: error_handler.get_message_list(l_error_msg_tbl);
3679: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
3680: l_msg_count := l_error_msg_tbl.FIRST;
3681: WHILE l_msg_count IS NOT NULL

Line 3736: ,p_init_msg_list => FND_API.G_FALSE

3732: LOOP
3733: eng_propagation_log_util.mark_component_change_transfer
3734: (
3735: p_api_version => 1.0
3736: ,p_init_msg_list => FND_API.G_FALSE
3737: ,p_commit => FND_API.G_FALSE
3738: ,x_return_status => l_return_status
3739: ,x_msg_count => l_msg_count
3740: ,x_msg_data => l_msg_data

Line 3737: ,p_commit => FND_API.G_FALSE

3733: eng_propagation_log_util.mark_component_change_transfer
3734: (
3735: p_api_version => 1.0
3736: ,p_init_msg_list => FND_API.G_FALSE
3737: ,p_commit => FND_API.G_FALSE
3738: ,x_return_status => l_return_status
3739: ,x_msg_count => l_msg_count
3740: ,x_msg_data => l_msg_data
3741: ,p_change_id => l_mark_comp_rec.change_id

Line 6586: ,p_commit => FND_API.G_FALSE

6582: END LOOP; -- FOR item_rec IN l_item_org_csr
6583: -- Call the Item's Org Assignment API for all the items together
6584: ego_item_org_assign_pvt.process_org_assignments
6585: ( p_item_org_assign_tab => l_item_org_assign_tbl
6586: ,p_commit => FND_API.G_FALSE
6587: ,p_context => 'BOM'
6588: ,x_return_status => l_return_status
6589: ,x_msg_count => l_msg_count
6590: );

Line 6592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6588: ,x_return_status => l_return_status
6589: ,x_msg_count => l_msg_count
6590: );
6591:
6592: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6593: THEN
6594: IF l_item_org_assign_tbl.FIRST IS NOT NULL
6595: THEN
6596: l_index := l_item_org_assign_tbl.FIRST;

Line 6599: IF l_item_org_assign_tbl(l_index).status <> FND_API.G_RET_STS_SUCCESS

6595: THEN
6596: l_index := l_item_org_assign_tbl.FIRST;
6597: WHILE l_index IS NOT NULL
6598: LOOP
6599: IF l_item_org_assign_tbl(l_index).status <> FND_API.G_RET_STS_SUCCESS
6600: THEN
6601: INSERT INTO mtl_interface_errors
6602: ( unique_id,
6603: organization_id,

Line 6640: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS

6636: NULL,
6637: fnd_global.conc_program_id,
6638: sysdate
6639: );
6640: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6641: l_index := l_item_org_assign_tbl.NEXT(l_index);
6642: END LOOP; -- WHILE l_index IS NOT NULL End Loop for items
6643: END IF; -- l_item_org_assign_tbl.FIRST IS NOT NULL
6644: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS When API returns non-success status

Line 6644: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS When API returns non-success status

6640: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6641: l_index := l_item_org_assign_tbl.NEXT(l_index);
6642: END LOOP; -- WHILE l_index IS NOT NULL End Loop for items
6643: END IF; -- l_item_org_assign_tbl.FIRST IS NOT NULL
6644: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS When API returns non-success status
6645:
6646: -- Sync up the index after item creation
6647: inv_item_pvt.sync_im_index;
6648: EXCEPTION

Line 6712: x_return_status := fnd_api.G_RET_STS_SUCCESS;

6708: l_count NUMBER := 0;
6709: l_index NUMBER := 0;
6710: l_effectivity_date DATE;
6711: BEGIN
6712: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6713: IF p_effectivity_date < sysdate THEN
6714: l_effectivity_date := sysdate;
6715: ELSE
6716: l_effectivity_date := p_effectivity_date;

Line 6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;

6823: WHERE oav.organization_id = x_org_list_tbl(l_index)
6824: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6825: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6826: l_index := x_org_list_tbl.next(l_index);
6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6828: EXCEPTION
6829: WHEN NO_DATA_FOUND THEN
6830: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6831: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 6831: x_return_status := fnd_api.G_RET_STS_ERROR;

6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6828: EXCEPTION
6829: WHEN NO_DATA_FOUND THEN
6830: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6831: x_return_status := fnd_api.G_RET_STS_ERROR;
6832: x_error_msg := fnd_message.get;
6833: RETURN;
6834: END;
6835: END LOOP;

Line 9618: ,p_init_msg_list => FND_API.G_FALSE

9614: LOOP
9615: eng_propagation_log_util.mark_component_change_transfer
9616: (
9617: p_api_version => 1.0
9618: ,p_init_msg_list => FND_API.G_FALSE
9619: ,p_commit => FND_API.G_FALSE
9620: ,x_return_status => l_return_status
9621: ,x_msg_count => l_msg_count
9622: ,x_msg_data => l_msg_data

Line 9619: ,p_commit => FND_API.G_FALSE

9615: eng_propagation_log_util.mark_component_change_transfer
9616: (
9617: p_api_version => 1.0
9618: ,p_init_msg_list => FND_API.G_FALSE
9619: ,p_commit => FND_API.G_FALSE
9620: ,x_return_status => l_return_status
9621: ,x_msg_count => l_msg_count
9622: ,x_msg_data => l_msg_data
9623: ,p_change_id => l_mark_comp_rec.change_id

Line 11651: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

11647: TRUE,
11648: p_assembly_item_id,
11649: p_component_item_id,
11650: p_org_id );
11651: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
11652: return NULL;
11653: ELSE
11654: return l_error_msg;
11655: END IF;