APPS.OE_INF_POPULATE_PUB dependencies on OE_PAYMENTS_INTERFACE

Line 1316: Insert into oe_payments_interface

1312:
1313:
1314: /* Line Level Payments */
1315:
1316: Insert into oe_payments_interface
1317: (
1318: ORDER_SOURCE_ID,
1319: change_sequence,
1320: PAYMENT_TRX_ID,

Line 1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1417: and line_id is not null;
1418:
1419: IF SQL%ROWCOUNT > 0 THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

Line 1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;

1421: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1422: END IF;
1423: ELSE
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR LINE' ) ;
1426: END IF;
1427: END IF;
1428:
1429: /* Header Payments */

Line 1431: Insert into oe_payments_interface

1427: END IF;
1428:
1429: /* Header Payments */
1430:
1431: Insert into oe_payments_interface
1432: (
1433: ORDER_SOURCE_ID,
1434: change_sequence,
1435: PAYMENT_TRX_ID,

Line 1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1532: and line_id is null;
1533:
1534: IF SQL%ROWCOUNT > 0 THEN
1535: IF l_debug_level > 0 THEN
1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

Line 1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;

1536: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1537: END IF;
1538: ELSE
1539: IF l_debug_level > 0 THEN
1540: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_PAYMENTS_INTERFACE FOR HEADERS' ) ;
1541: END IF;
1542: END IF;
1543:
1544: /* Line Level Price Adjustment */