DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_API

Line 1394: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1390: x_errorcode => l_errorcode,
1391: x_msg_count => l_msg_count,
1392: x_msg_data => l_msg_data
1393: );
1394: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1395: error_handler.get_message_list(l_error_msg_tbl);
1396: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
1397: l_msg_count := l_error_msg_tbl.FIRST;
1398: WHILE l_msg_count IS NOT NULL

Line 3739: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3735: x_errorcode => l_errorcode,
3736: x_msg_count => l_msg_count,
3737: x_msg_data => l_msg_data
3738: );
3739: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3740: error_handler.get_message_list(l_error_msg_tbl);
3741: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
3742: l_msg_count := l_error_msg_tbl.FIRST;
3743: WHILE l_msg_count IS NOT NULL

Line 3798: ,p_init_msg_list => FND_API.G_FALSE

3794: LOOP
3795: eng_propagation_log_util.mark_component_change_transfer
3796: (
3797: p_api_version => 1.0
3798: ,p_init_msg_list => FND_API.G_FALSE
3799: ,p_commit => FND_API.G_FALSE
3800: ,x_return_status => l_return_status
3801: ,x_msg_count => l_msg_count
3802: ,x_msg_data => l_msg_data

Line 3799: ,p_commit => FND_API.G_FALSE

3795: eng_propagation_log_util.mark_component_change_transfer
3796: (
3797: p_api_version => 1.0
3798: ,p_init_msg_list => FND_API.G_FALSE
3799: ,p_commit => FND_API.G_FALSE
3800: ,x_return_status => l_return_status
3801: ,x_msg_count => l_msg_count
3802: ,x_msg_data => l_msg_data
3803: ,p_change_id => l_mark_comp_rec.change_id

Line 6682: ,p_commit => FND_API.G_FALSE

6678: END LOOP; -- FOR item_rec IN l_item_org_csr
6679: -- Call the Item's Org Assignment API for all the items together
6680: ego_item_org_assign_pvt.process_org_assignments
6681: ( p_item_org_assign_tab => l_item_org_assign_tbl
6682: ,p_commit => FND_API.G_FALSE
6683: ,p_context => 'BOM'
6684: ,x_return_status => l_return_status
6685: ,x_msg_count => l_msg_count
6686: );

Line 6688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6684: ,x_return_status => l_return_status
6685: ,x_msg_count => l_msg_count
6686: );
6687:
6688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6689: THEN
6690: IF l_item_org_assign_tbl.FIRST IS NOT NULL
6691: THEN
6692: l_index := l_item_org_assign_tbl.FIRST;

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

6691: THEN
6692: l_index := l_item_org_assign_tbl.FIRST;
6693: WHILE l_index IS NOT NULL
6694: LOOP
6695: IF l_item_org_assign_tbl(l_index).status <> FND_API.G_RET_STS_SUCCESS
6696: THEN
6697: INSERT INTO mtl_interface_errors
6698: ( unique_id,
6699: organization_id,

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

6732: NULL,
6733: fnd_global.conc_program_id,
6734: sysdate
6735: );
6736: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6737: l_index := l_item_org_assign_tbl.NEXT(l_index);
6738: END LOOP; -- WHILE l_index IS NOT NULL End Loop for items
6739: END IF; -- l_item_org_assign_tbl.FIRST IS NOT NULL
6740: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS When API returns non-success status

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

6736: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6737: l_index := l_item_org_assign_tbl.NEXT(l_index);
6738: END LOOP; -- WHILE l_index IS NOT NULL End Loop for items
6739: END IF; -- l_item_org_assign_tbl.FIRST IS NOT NULL
6740: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS When API returns non-success status
6741:
6742: -- Sync up the index after item creation
6743: inv_item_pvt.sync_im_index;
6744: EXCEPTION

Line 6808: x_return_status := fnd_api.G_RET_STS_SUCCESS;

6804: l_count NUMBER := 0;
6805: l_index NUMBER := 0;
6806: l_effectivity_date DATE;
6807: BEGIN
6808: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6809: IF p_effectivity_date < sysdate THEN
6810: l_effectivity_date := sysdate;
6811: ELSE
6812: l_effectivity_date := p_effectivity_date;

Line 6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;

6919: WHERE oav.organization_id = x_org_list_tbl(l_index)
6920: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6921: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6922: l_index := x_org_list_tbl.next(l_index);
6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6924: EXCEPTION
6925: WHEN NO_DATA_FOUND THEN
6926: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6927: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 6927: x_return_status := fnd_api.G_RET_STS_ERROR;

6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6924: EXCEPTION
6925: WHEN NO_DATA_FOUND THEN
6926: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6927: x_return_status := fnd_api.G_RET_STS_ERROR;
6928: x_error_msg := fnd_message.get;
6929: RETURN;
6930: END;
6931: END LOOP;

Line 9771: ,p_init_msg_list => FND_API.G_FALSE

9767: LOOP
9768: eng_propagation_log_util.mark_component_change_transfer
9769: (
9770: p_api_version => 1.0
9771: ,p_init_msg_list => FND_API.G_FALSE
9772: ,p_commit => FND_API.G_FALSE
9773: ,x_return_status => l_return_status
9774: ,x_msg_count => l_msg_count
9775: ,x_msg_data => l_msg_data

Line 9772: ,p_commit => FND_API.G_FALSE

9768: eng_propagation_log_util.mark_component_change_transfer
9769: (
9770: p_api_version => 1.0
9771: ,p_init_msg_list => FND_API.G_FALSE
9772: ,p_commit => FND_API.G_FALSE
9773: ,x_return_status => l_return_status
9774: ,x_msg_count => l_msg_count
9775: ,x_msg_data => l_msg_data
9776: ,p_change_id => l_mark_comp_rec.change_id

Line 11804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

11800: TRUE,
11801: p_assembly_item_id,
11802: p_component_item_id,
11803: p_org_id );
11804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
11805: return NULL;
11806: ELSE
11807: return l_error_msg;
11808: END IF;

Line 11904: , p_commit => FND_API.G_FALSE

11900: l_item_org_assignment_tbl(1).Organization_Id := p_organization_id ;
11901:
11902: EGO_Item_PUB.Process_Item_Org_Assignments(
11903: p_api_version => 1.0
11904: , p_commit => FND_API.G_FALSE
11905: , p_Item_Org_Assignment_Tbl => l_item_org_assignment_tbl
11906: , x_msg_count => l_msg_count
11907: , x_return_status => l_return_status);
11908: END IF;

Line 11922: x_return_status := FND_API.G_RET_STS_ERROR;

11918: WHEN OTHERS THEN
11919: FND_MSG_PUB.Count_And_Get
11920: ( p_count => l_msg_count
11921: ,p_data => x_msg_data );
11922: x_return_status := FND_API.G_RET_STS_ERROR;
11923: END ASSIGN_ECO_COMP_TO_ORGS;
11924:
11925: END bom_copy_bill;