DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on CTO_CUSTOM_NOTIFY_PK

Line 1247: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED

1243: IF PG_DEBUG <> 0 THEN
1244: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1245: END IF;
1246:
1247: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_CREATED
1248: ,p_inventory_item_id => pModelId
1249: ,p_organization_id => lNextRec.organization_id
1250: ,p_line_id => pLineId );
1251:

Line 1257: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);

1253:
1254:
1255: if( v_recipient is not null ) then
1256: IF PG_DEBUG <> 0 THEN
1257: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);
1258: END IF;
1259:
1260: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1261:

Line 1264: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);

1260: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1261:
1262: else
1263: IF PG_DEBUG <> 0 THEN
1264: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1265: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1266: END IF;
1267:
1268: BEGIN

Line 1359: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED

1355: IF PG_DEBUG <> 0 THEN
1356: oe_debug_pub.add('create_bom_ml: ' || 'Getting Custom Recipient..',3);
1357: END IF;
1358:
1359: v_recipient := CTO_CUSTOM_NOTIFY_PK.get_recipient( p_error_type => CTO_UTILITY_PK.OPT_DROP_AND_ITEM_NOT_CREATED
1360: ,p_inventory_item_id => pModelId
1361: ,p_organization_id => lNextRec.organization_id
1362: ,p_line_id => pLineId );
1363:

Line 1369: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);

1365:
1366:
1367: if( v_recipient is not null ) then
1368: IF PG_DEBUG <> 0 THEN
1369: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK..' || v_recipient ,3);
1370: END IF;
1371:
1372: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).NOTIFY_USER := v_recipient ; /* commented 'MFG' */
1373:

Line 1377: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);

1373:
1374: else
1375:
1376: IF PG_DEBUG <> 0 THEN
1377: oe_debug_pub.add('create_bom_ml: ' || 'Recipient returned from CTO_CUSTOM_NOTIFY_PK is null ..' , 3);
1378: oe_debug_pub.add('create_bom_ml: ' || 'Getting the planner code ..',3);
1379: END IF;
1380:
1381: BEGIN