APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on CTO_UTILITY_PK

Line 1076: CTO_UTILITY_PK.QUERY_SOURCING_ORG(

1072: pitems_table(l_index).feeder_run := 'N';
1073:
1074:
1075: l_stmt_num := 50;
1076: CTO_UTILITY_PK.QUERY_SOURCING_ORG(
1077: P_inventory_item_id => pitems_table(l_index).item_id,
1078: P_organization_id => pOrganization_id,
1079: P_sourcing_rule_exists => v_sourcing_rule_exists,
1080: P_source_type => v_source_type,

Line 1089: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1085: );
1086:
1087: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1088: IF PG_DEBUG <> 0 THEN
1089: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1090: END IF;
1091: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1095: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1091: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094: IF PG_DEBUG <> 0 THEN
1095: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1096: END IF;
1097: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSE

Line 1102: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSE
1100:
1101: IF PG_DEBUG <> 0 THEN
1102: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);
1103: END IF;
1104: END IF;
1105:
1106:

Line 1304: CTO_UTILITY_PK.QUERY_SOURCING_ORG(

1300: pitems_table(l_index).feeder_run := 'N';
1301:
1302: l_stmt_num := 80;
1303:
1304: CTO_UTILITY_PK.QUERY_SOURCING_ORG(
1305: P_inventory_item_id => pitems_table(l_index).item_id,
1306: P_organization_id => pOrganization_id,
1307: P_sourcing_rule_exists => v_sourcing_rule_exists,
1308: P_source_type => v_source_type,

Line 1317: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1313: );
1314:
1315: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1316: IF PG_DEBUG <> 0 THEN
1317: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1318: END IF;
1319: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1323: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1319: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1320: RAISE FND_API.G_EXC_ERROR;
1321: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1322: IF PG_DEBUG <> 0 THEN
1323: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1324: END IF;
1325: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSE

Line 1330: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSE
1328:
1329: IF PG_DEBUG <> 0 THEN
1330: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);
1331: END IF;
1332: END IF;
1333:
1334: