DBA Data[Home] [Help]

APPS.PV_ORDER_MGMT_PVT dependencies on PVX_UTILITY_PVT

Line 59: PVX_UTILITY_PVT.debug_message('before updating the processing messages table');

55: IF (PV_DEBUG_HIGH_ON) THEN
56:
57:
58:
59: PVX_UTILITY_PVT.debug_message('before updating the processing messages table');
60:
61: END IF;
62:
63: FOR k IN 1 .. l_msg_count LOOP

Line 71: PVX_UTILITY_PVT.debug_message('before calling oe_msg_pub.get');

67: IF (PV_DEBUG_HIGH_ON) THEN
68:
69:
70:
71: PVX_UTILITY_PVT.debug_message('before calling oe_msg_pub.get');
72:
73: END IF;
74: oe_msg_pub.get (
75: p_msg_index => k

Line 83: PVX_UTILITY_PVT.debug_message('In index.message_text is null');

79:
80: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
81: IF (PV_DEBUG_HIGH_ON) THEN
82:
83: PVX_UTILITY_PVT.debug_message('In index.message_text is null');
84: END IF;
85: x_msg_data := oe_msg_pub.get(l_msg_index, 'F');
86: END IF;
87:

Line 94: PVX_UTILITY_PVT.debug_message('x_msg_data ' || x_msg_data);

90: IF (PV_DEBUG_HIGH_ON) THEN
91:
92:
93:
94: PVX_UTILITY_PVT.debug_message('x_msg_data ' || x_msg_data);
95:
96: END IF;
97:
98: l_len_sqlerrm := Length(x_msg_data) ;

Line 130: PVX_UTILITY_PVT.debug_message('OE Debug on ' || l_debug_on);

126:
127: l_debug_on := FND_PROFILE.Value('SO_DEBUG');
128:
129: IF (PV_DEBUG_HIGH_ON) THEN
130: PVX_UTILITY_PVT.debug_message('OE Debug on ' || l_debug_on);
131: END IF;
132:
133: IF (l_debug_on = 'Y' )THEN
134: for x in c_debug_directory loop

Line 150: PVX_UTILITY_PVT.debug_message('Debug File ' || l_file_val);

146: oe_debug_pub.initialize;
147: OE_DEBUG_PUB.G_DIR := l_debug_dir;
148: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
149: IF (PV_DEBUG_HIGH_ON) THEN
150: PVX_UTILITY_PVT.debug_message('Debug File ' || l_file_val);
151: END IF;
152: END IF;
153:
154: END Order_Debug_On;

Line 172: PVX_UTILITY_PVT.debug_message(' begin : set_mo_policy_context: ' );

168:
169: BEGIN
170:
171: IF (PV_DEBUG_HIGH_ON) THEN
172: PVX_UTILITY_PVT.debug_message(' begin : set_mo_policy_context: ' );
173: END IF;
174:
175: curr_org := mo_global.get_current_org_id;
176:

Line 178: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: p_order_header_id ' || p_order_header_id);

174:
175: curr_org := mo_global.get_current_org_id;
176:
177: IF (PV_DEBUG_HIGH_ON) THEN
178: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: p_order_header_id ' || p_order_header_id);
179: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: curr_org ' || curr_org);
180: END IF;
181:
182: OPEN c_order_header_id(p_order_header_id);

Line 179: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: curr_org ' || curr_org);

175: curr_org := mo_global.get_current_org_id;
176:
177: IF (PV_DEBUG_HIGH_ON) THEN
178: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: p_order_header_id ' || p_order_header_id);
179: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: curr_org ' || curr_org);
180: END IF;
181:
182: OPEN c_order_header_id(p_order_header_id);
183: FETCH c_order_header_id into order_org;

Line 187: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: order_org ' || order_org);

183: FETCH c_order_header_id into order_org;
184: CLOSE c_order_header_id;
185:
186: IF (PV_DEBUG_HIGH_ON) THEN
187: PVX_UTILITY_PVT.debug_message('set_mo_policy_context: order_org ' || order_org);
188: END IF;
189:
190: if ((curr_org is null or curr_org <> order_org) and order_org is not null) then
191: mo_global.set_policy_context('S', order_org);

Line 193: PVX_UTILITY_PVT.debug_message('call mo_global.set_policy_context set single org');

189:
190: if ((curr_org is null or curr_org <> order_org) and order_org is not null) then
191: mo_global.set_policy_context('S', order_org);
192: IF (PV_DEBUG_HIGH_ON) THEN
193: PVX_UTILITY_PVT.debug_message('call mo_global.set_policy_context set single org');
194: END IF;
195: end if;
196:
197: IF (PV_DEBUG_HIGH_ON) THEN

Line 198: PVX_UTILITY_PVT.debug_message(' end : set_mo_policy_context: ' );

194: END IF;
195: end if;
196:
197: IF (PV_DEBUG_HIGH_ON) THEN
198: PVX_UTILITY_PVT.debug_message(' end : set_mo_policy_context: ' );
199: END IF;
200:
201: END set_mo_policy_context;
202:

Line 308: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

304:
305: -- Debug Message
306: IF (PV_DEBUG_HIGH_ON) THEN
307:
308: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
309: END IF;
310:
311:
312: -- Initialize API return status to SUCCESS

Line 414: PVX_UTILITY_PVT.debug_message('Partner Accoutn ID : ' || p_partner_account_id);

410:
411:
412: IF (PV_DEBUG_HIGH_ON) THEN
413:
414: PVX_UTILITY_PVT.debug_message('Partner Accoutn ID : ' || p_partner_account_id);
415:
416: END IF;
417:
418:

Line 432: PVX_UTILITY_PVT.debug_message('-----Get generic party_id based on party_site_id------');

428: */
429:
430: IF (PV_DEBUG_HIGH_ON) THEN
431:
432: PVX_UTILITY_PVT.debug_message('-----Get generic party_id based on party_site_id------');
433: END IF;
434:
435: select party_id
436: into l_party_id

Line 454: PVX_UTILITY_PVT.debug_message('-----Get Invoice to Org ID------');

450: END IF;
451:
452: IF (PV_DEBUG_HIGH_ON) THEN
453:
454: PVX_UTILITY_PVT.debug_message('-----Get Invoice to Org ID------');
455: END IF;
456: PV_PARTNER_ACCNT_MGMT_PVT.Get_acct_site_uses(
457: p_party_site_id => p_party_site_id,
458: p_acct_site_type => 'BILL_TO',

Line 468: PVX_UTILITY_PVT.debug_message('l_bill_to_site_use_id : ' ||l_bill_to_site_use_id);

464: );
465:
466: IF (PV_DEBUG_HIGH_ON) THEN
467:
468: PVX_UTILITY_PVT.debug_message('l_bill_to_site_use_id : ' ||l_bill_to_site_use_id);
469: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
470:
471: END IF;
472:

Line 469: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);

465:
466: IF (PV_DEBUG_HIGH_ON) THEN
467:
468: PVX_UTILITY_PVT.debug_message('l_bill_to_site_use_id : ' ||l_bill_to_site_use_id);
469: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
470:
471: END IF;
472:
473: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 485: PVX_UTILITY_PVT.debug_message('---------Get Ship To Org ID-----------');

481:
482: -----------------End of get Invoice to Org ID--------------------------------
483: IF (PV_DEBUG_HIGH_ON) THEN
484:
485: PVX_UTILITY_PVT.debug_message('---------Get Ship To Org ID-----------');
486: END IF;
487:
488: PV_PARTNER_ACCNT_MGMT_PVT.Get_acct_site_uses(
489: p_party_site_id => p_party_site_id,

Line 500: PVX_UTILITY_PVT.debug_message('l_ship_to_site_use_id : ' ||l_ship_to_site_use_id);

496: );
497:
498: IF (PV_DEBUG_HIGH_ON) THEN
499:
500: PVX_UTILITY_PVT.debug_message('l_ship_to_site_use_id : ' ||l_ship_to_site_use_id);
501: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
502:
503: END IF;
504: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 501: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);

497:
498: IF (PV_DEBUG_HIGH_ON) THEN
499:
500: PVX_UTILITY_PVT.debug_message('l_ship_to_site_use_id : ' ||l_ship_to_site_use_id);
501: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
502:
503: END IF;
504: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
505: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 516: PVX_UTILITY_PVT.debug_message('----- Get Contact Role--------');

512:
513: ---------------End of Ship Org ID----------------------------------
514: IF (PV_DEBUG_HIGH_ON) THEN
515:
516: PVX_UTILITY_PVT.debug_message('----- Get Contact Role--------');
517: END IF;
518:
519: PV_PARTNER_ACCNT_MGMT_PVT.Get_cust_acct_roles(
520: p_contact_party_id => p_contact_party_id,

Line 529: PVX_UTILITY_PVT.debug_message('l_cust_account_role_id : ' ||l_cust_account_role_id);

525: );
526:
527: IF (PV_DEBUG_HIGH_ON) THEN
528:
529: PVX_UTILITY_PVT.debug_message('l_cust_account_role_id : ' ||l_cust_account_role_id);
530: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
531:
532: END IF;
533:

Line 530: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);

526:
527: IF (PV_DEBUG_HIGH_ON) THEN
528:
529: PVX_UTILITY_PVT.debug_message('l_cust_account_role_id : ' ||l_cust_account_role_id);
530: PVX_UTILITY_PVT.debug_message('l_return_status : ' || l_return_status);
531:
532: END IF;
533:
534: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 547: PVX_UTILITY_PVT.debug_message('Before header rec initialization');

543:
544:
545:
546: IF (PV_DEBUG_HIGH_ON) THEN
547: PVX_UTILITY_PVT.debug_message('Before header rec initialization');
548: END IF;
549:
550: x_order_header_id := JTF_NUMBER_TABLE();
551:

Line 632: PVX_UTILITY_PVT.debug_message('Just before order call');

628: IF (PV_DEBUG_HIGH_ON) THEN
629:
630:
631:
632: PVX_UTILITY_PVT.debug_message('Just before order call');
633:
634: END IF;
635:
636: --kvattiku: Aug 08, 05 Changed the x_line_tbl initialization to l_line_out_tbl and x_header_rec

Line 673: PVX_UTILITY_PVT.debug_message('X_return_status ' || x_return_status);

669: x_action_request_tbl =>x_action_request_tbl
670: );
671:
672: IF (PV_DEBUG_HIGH_ON) THEN
673: PVX_UTILITY_PVT.debug_message('X_return_status ' || x_return_status);
674: PVX_UTILITY_PVT.debug_message('X_msg_count ' || x_msg_count);
675: PVX_UTILITY_PVT.debug_message('X_msg_data ' || x_msg_data);
676: END IF;
677:

Line 674: PVX_UTILITY_PVT.debug_message('X_msg_count ' || x_msg_count);

670: );
671:
672: IF (PV_DEBUG_HIGH_ON) THEN
673: PVX_UTILITY_PVT.debug_message('X_return_status ' || x_return_status);
674: PVX_UTILITY_PVT.debug_message('X_msg_count ' || x_msg_count);
675: PVX_UTILITY_PVT.debug_message('X_msg_data ' || x_msg_data);
676: END IF;
677:
678:

Line 675: PVX_UTILITY_PVT.debug_message('X_msg_data ' || x_msg_data);

671:
672: IF (PV_DEBUG_HIGH_ON) THEN
673: PVX_UTILITY_PVT.debug_message('X_return_status ' || x_return_status);
674: PVX_UTILITY_PVT.debug_message('X_msg_count ' || x_msg_count);
675: PVX_UTILITY_PVT.debug_message('X_msg_data ' || x_msg_data);
676: END IF;
677:
678:
679: x_order_header_id.extend;

Line 687: PVX_UTILITY_PVT.debug_message('x_order_header_id : '|| i|| ' : ' || x_order_header_id(x_order_header_id.count));

683: x_order_header_id(x_order_header_id.count) := l_header_out_rec.header_id;
684:
685: IF (PV_DEBUG_HIGH_ON) THEN
686:
687: PVX_UTILITY_PVT.debug_message('x_order_header_id : '|| i|| ' : ' || x_order_header_id(x_order_header_id.count));
688: END IF;
689: Retrieve_OE_Messages;
690:
691: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 822: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

818:
819: -- Debug Message
820: IF (PV_DEBUG_HIGH_ON) THEN
821:
822: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
823: END IF;
824:
825:
826: -- Initialize API return status to SUCCESS

Line 1026: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

1022:
1023: -- Debug Message
1024: IF (PV_DEBUG_HIGH_ON) THEN
1025:
1026: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
1027: END IF;
1028:
1029:
1030: -- Initialize API return status to SUCCESS

Line 1225: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');

1221:
1222: -- Debug Message
1223: IF (PV_DEBUG_HIGH_ON) THEN
1224:
1225: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
1226: END IF;
1227:
1228:
1229: -- Initialize API return status to SUCCESS

Line 1287: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);

1283: x_action_request_tbl =>x_action_request_tbl
1284: );
1285:
1286: IF (PV_DEBUG_HIGH_ON) THEN
1287: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1288: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1289: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1290: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl.COUNT : ' || x_action_request_tbl.COUNT);
1291: END IF;

Line 1288: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);

1284: );
1285:
1286: IF (PV_DEBUG_HIGH_ON) THEN
1287: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1288: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1289: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1290: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl.COUNT : ' || x_action_request_tbl.COUNT);
1291: END IF;
1292:

Line 1289: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);

1285:
1286: IF (PV_DEBUG_HIGH_ON) THEN
1287: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1288: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1289: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1290: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl.COUNT : ' || x_action_request_tbl.COUNT);
1291: END IF;
1292:
1293: Retrieve_OE_Messages;

Line 1290: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl.COUNT : ' || x_action_request_tbl.COUNT);

1286: IF (PV_DEBUG_HIGH_ON) THEN
1287: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1288: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1289: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1290: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl.COUNT : ' || x_action_request_tbl.COUNT);
1291: END IF;
1292:
1293: Retrieve_OE_Messages;
1294:

Line 1301: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl(i).return_status : ' || x_action_request_tbl(i).return_status);

1297: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1300: FOR i in 1..x_action_request_tbl.COUNT LOOP
1301: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl(i).return_status : ' || x_action_request_tbl(i).return_status);
1302: IF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_ERROR THEN
1303: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);
1304: RAISE FND_API.g_exc_error;
1305: ELSIF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1303: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);

1299: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1300: FOR i in 1..x_action_request_tbl.COUNT LOOP
1301: PVX_UTILITY_PVT.debug_message('process_order :: x_action_request_tbl(i).return_status : ' || x_action_request_tbl(i).return_status);
1302: IF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_ERROR THEN
1303: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);
1304: RAISE FND_API.g_exc_error;
1305: ELSIF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);
1307: RAISE FND_API.g_exc_error;

Line 1306: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);

1302: IF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_ERROR THEN
1303: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);
1304: RAISE FND_API.g_exc_error;
1305: ELSIF x_action_request_tbl(i).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1306: PVX_UTILITY_PVT.debug_message('x_action_request_tbl.return_status is ' || x_action_request_tbl(i).return_status);
1307: RAISE FND_API.g_exc_error;
1308: END IF;
1309: END LOOP;
1310: END IF;

Line 1428: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');

1424:
1425: -- Debug Message
1426: IF (PV_DEBUG_HIGH_ON) THEN
1427:
1428: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
1429: END IF;
1430:
1431:
1432: -- Initialize API return status to SUCCESS

Line 1508: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);

1504: x_action_request_tbl =>x_action_request_tbl
1505: );
1506:
1507: IF (PV_DEBUG_HIGH_ON) THEN
1508: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1509: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1510: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1511: END IF;
1512:

Line 1509: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);

1505: );
1506:
1507: IF (PV_DEBUG_HIGH_ON) THEN
1508: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1509: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1510: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1511: END IF;
1512:
1513: Retrieve_OE_Messages;

Line 1510: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);

1506:
1507: IF (PV_DEBUG_HIGH_ON) THEN
1508: PVX_UTILITY_PVT.debug_message('process_order :: x_return_status : ' || x_return_status);
1509: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_data : ' || x_msg_data);
1510: PVX_UTILITY_PVT.debug_message('process_order :: x_msg_count : ' || x_msg_count);
1511: END IF;
1512:
1513: Retrieve_OE_Messages;
1514:

Line 1621: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');

1617:
1618: -- Debug Message
1619: IF (PV_DEBUG_HIGH_ON) THEN
1620:
1621: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
1622: END IF;
1623:
1624:
1625: -- Initialize API return status to SUCCESS

Line 1851: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

1847:
1848: -- Debug Message
1849: IF (PV_DEBUG_HIGH_ON) THEN
1850:
1851: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
1852: END IF;
1853:
1854:
1855: -- Initialize API return status to SUCCESS

Line 1907: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Payment Type : ' || p_payment_method_rec.payment_type_code );

1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905:
1906: IF (PV_DEBUG_HIGH_ON) THEN
1907: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Payment Type : ' || p_payment_method_rec.payment_type_code );
1908: END IF;
1909:
1910:
1911:

Line 1953: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after call to get_payment_channel_attribs');

1949:
1950:
1951: -- Debug Message
1952: IF (PV_DEBUG_HIGH_ON) THEN
1953: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after call to get_payment_channel_attribs');
1954: END IF;
1955:
1956: -- Debug Message
1957: IF (PV_DEBUG_HIGH_ON) THEN

Line 1958: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' CVV2 : ' || l_payment_attribs.Instr_SecCode_Use);

1954: END IF;
1955:
1956: -- Debug Message
1957: IF (PV_DEBUG_HIGH_ON) THEN
1958: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' CVV2 : ' || l_payment_attribs.Instr_SecCode_Use);
1959: END IF;
1960:
1961:
1962:

Line 1983: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Entered the instr_assignment_id is NULL block');

1979: IF (p_payment_method_rec.instr_assignment_id IS NULL) THEN
1980:
1981: -- Debug Message
1982: IF (PV_DEBUG_HIGH_ON) THEN
1983: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Entered the instr_assignment_id is NULL block');
1984: END IF;
1985:
1986:
1987: IF (p_payment_method_rec.credit_card_holder_name = FND_API.G_MISS_CHAR or p_payment_method_rec.credit_card_holder_name IS NULL) THEN

Line 2023: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Billing Address : ' || l_payment_attribs.Instr_Billing_Address);

2019:
2020: --kvattiku Aug 14, 05
2021: -- Debug Message
2022: IF (PV_DEBUG_HIGH_ON) THEN
2023: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Billing Address : ' || l_payment_attribs.Instr_Billing_Address);
2024: END IF;
2025:
2026: IF (l_payment_attribs.Instr_Billing_Address = 'REQUIRED') THEN
2027: IF (p_payment_method_rec.cc_stmt_party_site_id = FND_API.G_MISS_NUM or p_payment_method_rec.cc_stmt_party_site_id IS NULL) THEN

Line 2034: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party site id = ' || p_payment_method_rec.cc_stmt_party_site_id);

2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;
2032:
2033: IF (PV_DEBUG_HIGH_ON) THEN
2034: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party site id = ' || p_payment_method_rec.cc_stmt_party_site_id);
2035: END IF;
2036:
2037: select hzp.party_type,
2038: hzs.location_id

Line 2047: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' contact party id = ' || p_contact_party_id);

2043: where hzs.party_site_id = p_payment_method_rec.cc_stmt_party_site_id
2044: and hzp.party_id = hzs.party_id;
2045:
2046: IF (PV_DEBUG_HIGH_ON) THEN
2047: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' contact party id = ' || p_contact_party_id);
2048: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party type = ' || l_party_type);
2049: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' location id = ' || l_location_id);
2050: END IF;
2051:

Line 2048: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party type = ' || l_party_type);

2044: and hzp.party_id = hzs.party_id;
2045:
2046: IF (PV_DEBUG_HIGH_ON) THEN
2047: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' contact party id = ' || p_contact_party_id);
2048: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party type = ' || l_party_type);
2049: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' location id = ' || l_location_id);
2050: END IF;
2051:
2052: IF (l_party_type = 'ORGANIZATION') THEN

Line 2049: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' location id = ' || l_location_id);

2045:
2046: IF (PV_DEBUG_HIGH_ON) THEN
2047: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' contact party id = ' || p_contact_party_id);
2048: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' party type = ' || l_party_type);
2049: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' location id = ' || l_location_id);
2050: END IF;
2051:
2052: IF (l_party_type = 'ORGANIZATION') THEN
2053:

Line 2060: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Contact''s party site id = ' || l_party_site_id);

2056: p_location_id => l_location_id
2057: );
2058:
2059: IF (PV_DEBUG_HIGH_ON) THEN
2060: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Contact''s party site id = ' || l_party_site_id);
2061: END IF;
2062:
2063: IF (l_party_site_id IS NULL) THEN
2064: l_party_site_rec.party_id := p_contact_party_id;

Line 2070: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.party_id = ' ||

2066: l_party_site_rec.identifying_address_flag := 'N';
2067: l_party_site_rec.created_by_module := 'PV';
2068:
2069: IF (PV_DEBUG_HIGH_ON) THEN
2070: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.party_id = ' ||
2071: p_contact_party_id);
2072: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.location_id = ' ||
2073: l_location_id);
2074: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.identifying_address_flag = ' ||

Line 2072: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.location_id = ' ||

2068:
2069: IF (PV_DEBUG_HIGH_ON) THEN
2070: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.party_id = ' ||
2071: p_contact_party_id);
2072: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.location_id = ' ||
2073: l_location_id);
2074: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.identifying_address_flag = ' ||
2075: 'N');
2076: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.created_by_module = ' ||

Line 2074: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.identifying_address_flag = ' ||

2070: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.party_id = ' ||
2071: p_contact_party_id);
2072: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.location_id = ' ||
2073: l_location_id);
2074: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.identifying_address_flag = ' ||
2075: 'N');
2076: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.created_by_module = ' ||
2077: 'PV');
2078: END IF;

Line 2076: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.created_by_module = ' ||

2072: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.location_id = ' ||
2073: l_location_id);
2074: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.identifying_address_flag = ' ||
2075: 'N');
2076: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Before HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_rec.created_by_module = ' ||
2077: 'PV');
2078: END IF;
2079:
2080: HZ_PARTY_SITE_V2PUB.create_party_site (

Line 2095: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_id = ' || l_party_site_id);

2091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2092: END IF;
2093:
2094: IF (PV_DEBUG_HIGH_ON) THEN
2095: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_id = ' || l_party_site_id);
2096: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_number = ' || l_party_site_number);
2097: END IF;
2098:
2099: END IF;

Line 2096: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_number = ' || l_party_site_number);

2092: END IF;
2093:
2094: IF (PV_DEBUG_HIGH_ON) THEN
2095: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_id = ' || l_party_site_id);
2096: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' After HZ_PARTY_SITE_V2PUB.create_party_site l_party_site_number = ' || l_party_site_number);
2097: END IF;
2098:
2099: END IF;
2100: ELSE

Line 2110: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' l_party_site_id : ' || l_party_site_id);

2106:
2107:
2108: -- Debug Message
2109: IF (PV_DEBUG_HIGH_ON) THEN
2110: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' l_party_site_id : ' || l_party_site_id);
2111: END IF;
2112:
2113:
2114: /* Create Card and get Intrument Assignment ID*/

Line 2140: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_SETUP_PUB.process_credit_card call');

2136:
2137:
2138: -- Debug Message
2139: IF (PV_DEBUG_HIGH_ON) THEN
2140: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_SETUP_PUB.process_credit_card call');
2141: END IF;
2142:
2143:
2144: IBY_FNDCPT_SETUP_PUB.process_credit_card

Line 2161: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_return_status);

2157: );
2158:
2159: -- Debug Message
2160: IF (PV_DEBUG_HIGH_ON) THEN
2161: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_return_status);
2162: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_count);
2163: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_data);
2164: END IF;
2165:

Line 2162: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_count);

2158:
2159: -- Debug Message
2160: IF (PV_DEBUG_HIGH_ON) THEN
2161: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_return_status);
2162: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_count);
2163: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_data);
2164: END IF;
2165:
2166:

Line 2163: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_data);

2159: -- Debug Message
2160: IF (PV_DEBUG_HIGH_ON) THEN
2161: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_return_status);
2162: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_count);
2163: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_SETUP_PUB.process_credit_card call: ' || x_msg_data);
2164: END IF;
2165:
2166:
2167:

Line 2181: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_SETUP_PUB.process_credit_card call');

2177: END IF;
2178:
2179: -- Debug Message
2180: IF (PV_DEBUG_HIGH_ON) THEN
2181: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_SETUP_PUB.process_credit_card call');
2182: END IF;
2183:
2184: ELSE
2185: lx_instr_assign_id := p_payment_method_rec.instr_assignment_id;

Line 2190: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);

2186: END IF; --inst_assignment_id is null
2187: END IF; -- p_payment_method_rec.payment_type_code = 'CHECK' or 'CREDIT_CARD'
2188:
2189: IF (PV_DEBUG_HIGH_ON) THEN
2190: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);
2191: END IF;
2192:
2193:
2194: FOR x in c_get_payment_amount(l_order_header_id_tbl) loop

Line 2198: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Entered the c_get_payment_amount for loop');

2194: FOR x in c_get_payment_amount(l_order_header_id_tbl) loop
2195:
2196: -- Debug Message
2197: IF (PV_DEBUG_HIGH_ON) THEN
2198: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' Entered the c_get_payment_amount for loop');
2199: END IF;
2200:
2201: x_enrl_info(x.header_id).payment_amount := x.payment_amount;
2202: x_enrl_info(x.header_id).currency := x.currency;

Line 2209: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');

2205: IF ((p_payment_method_rec.payment_type_code <> 'CREDIT_CARD') and (x_enrl_info(x.header_id).trxn_extension_id IS NOT NULL) and
2206: (p_enrollment_flow = 'Y')) THEN
2207: -- Debug Message
2208: IF (PV_DEBUG_HIGH_ON) THEN
2209: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');
2210: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2211: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2212: END IF;
2213:

Line 2210: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);

2206: (p_enrollment_flow = 'Y')) THEN
2207: -- Debug Message
2208: IF (PV_DEBUG_HIGH_ON) THEN
2209: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');
2210: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2211: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2212: END IF;
2213:
2214: l_payer.party_id := p_contact_party_id;

Line 2211: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);

2207: -- Debug Message
2208: IF (PV_DEBUG_HIGH_ON) THEN
2209: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');
2210: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2211: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2212: END IF;
2213:
2214: l_payer.party_id := p_contact_party_id;
2215:

Line 2231: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_return_status);

2227: x_response => lx_response
2228: );
2229:
2230: IF (PV_DEBUG_HIGH_ON) THEN
2231: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_return_status);
2232: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_count);
2233: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_data);
2234: END IF;
2235:

Line 2232: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_count);

2228: );
2229:
2230: IF (PV_DEBUG_HIGH_ON) THEN
2231: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_return_status);
2232: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_count);
2233: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_data);
2234: END IF;
2235:
2236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2233: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_data);

2229:
2230: IF (PV_DEBUG_HIGH_ON) THEN
2231: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_return_status);
2232: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_count);
2233: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension : ' || x_msg_data);
2234: END IF;
2235:
2236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2237: IF ((lx_response.Result_Category = 'INVALID_PARAM') or (lx_response.Result_Category = 'INCORRECT_FLOW')) THEN

Line 2251: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');

2247: x_enrl_info(x.header_id).trxn_extension_id := null;
2248:
2249: -- Debug Message
2250: IF (PV_DEBUG_HIGH_ON) THEN
2251: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');
2252: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2253: END IF;
2254:
2255: ELSIF (p_payment_method_rec.payment_type_code = 'CREDIT_CARD') THEN

Line 2252: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);

2248:
2249: -- Debug Message
2250: IF (PV_DEBUG_HIGH_ON) THEN
2251: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension call');
2252: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2253: END IF;
2254:
2255: ELSIF (p_payment_method_rec.payment_type_code = 'CREDIT_CARD') THEN
2256:

Line 2265: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL)');

2261: */
2262:
2263: -- Debug Message
2264: IF (PV_DEBUG_HIGH_ON) THEN
2265: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL)');
2266: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id.trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);
2268: IF (p_enrollment_flow = 'Y') THEN
2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);

Line 2266: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id.trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);

2262:
2263: -- Debug Message
2264: IF (PV_DEBUG_HIGH_ON) THEN
2265: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL)');
2266: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id.trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);
2268: IF (p_enrollment_flow = 'Y') THEN
2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2270: ELSE

Line 2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);

2263: -- Debug Message
2264: IF (PV_DEBUG_HIGH_ON) THEN
2265: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL)');
2266: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id.trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);
2268: IF (p_enrollment_flow = 'Y') THEN
2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2270: ELSE
2271: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);

Line 2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);

2265: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL)');
2266: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id.trxn_extension_id ' || x_enrl_info(x.header_id).trxn_extension_id);
2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);
2268: IF (p_enrollment_flow = 'Y') THEN
2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2270: ELSE
2271: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);
2272: END IF;
2273: END IF;

Line 2271: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);

2267: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).order_header_id ' || x_enrl_info(x.header_id).order_header_id);
2268: IF (p_enrollment_flow = 'Y') THEN
2269: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2270: ELSE
2271: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);
2272: END IF;
2273: END IF;
2274:
2275: l_trxn_attribs.instrument_security_code := p_payment_method_rec.instrument_security_code;

Line 2291: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');

2287:
2288: IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL) THEN
2289: -- Debug Message
2290: IF (PV_DEBUG_HIGH_ON) THEN
2291: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2292: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_payment_method_rec.instrument_security_code ' || p_payment_method_rec.instrument_security_code);
2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2294: IF (p_enrollment_flow = 'Y') THEN
2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);

Line 2292: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_payment_method_rec.instrument_security_code ' || p_payment_method_rec.instrument_security_code);

2288: IF (x_enrl_info(x.header_id).trxn_extension_id IS NULL) THEN
2289: -- Debug Message
2290: IF (PV_DEBUG_HIGH_ON) THEN
2291: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2292: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_payment_method_rec.instrument_security_code ' || p_payment_method_rec.instrument_security_code);
2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2294: IF (p_enrollment_flow = 'Y') THEN
2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2296: ELSE

Line 2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);

2289: -- Debug Message
2290: IF (PV_DEBUG_HIGH_ON) THEN
2291: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2292: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_payment_method_rec.instrument_security_code ' || p_payment_method_rec.instrument_security_code);
2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2294: IF (p_enrollment_flow = 'Y') THEN
2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2296: ELSE
2297: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);

Line 2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);

2291: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2292: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_payment_method_rec.instrument_security_code ' || p_payment_method_rec.instrument_security_code);
2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2294: IF (p_enrollment_flow = 'Y') THEN
2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2296: ELSE
2297: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);
2298: END IF;
2299: END IF;

Line 2297: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);

2293: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' p_contact_party_id ' || p_contact_party_id);
2294: IF (p_enrollment_flow = 'Y') THEN
2295: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).enrl_req_id ' || x_enrl_info(x.header_id).enrl_req_id);
2296: ELSE
2297: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_enrl_info(x.header_id).invite_header_id ' || x_enrl_info(x.header_id).invite_header_id);
2298: END IF;
2299: END IF;
2300:
2301: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension

Line 2319: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_return_status);

2315: x_response => lx_response
2316: );
2317:
2318: IF (PV_DEBUG_HIGH_ON) THEN
2319: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_return_status);
2320: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_count);
2321: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_data);
2322: END IF;
2323:

Line 2320: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_count);

2316: );
2317:
2318: IF (PV_DEBUG_HIGH_ON) THEN
2319: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_return_status);
2320: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_count);
2321: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_data);
2322: END IF;
2323:
2324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2321: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_data);

2317:
2318: IF (PV_DEBUG_HIGH_ON) THEN
2319: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_return_status);
2320: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_count);
2321: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension : ' || x_msg_data);
2322: END IF;
2323:
2324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2325: IF (lx_response.Result_Category = 'INVALID_PARAM') THEN

Line 2339: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');

2335: x_enrl_info(x.header_id).trxn_extension_id := lx_trxn_extension_id;
2336:
2337: -- Debug Message
2338: IF (PV_DEBUG_HIGH_ON) THEN
2339: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2340: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_trxn_extension_id ' || lx_trxn_extension_id);
2341: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);
2342: END IF;
2343:

Line 2340: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_trxn_extension_id ' || lx_trxn_extension_id);

2336:
2337: -- Debug Message
2338: IF (PV_DEBUG_HIGH_ON) THEN
2339: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2340: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_trxn_extension_id ' || lx_trxn_extension_id);
2341: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);
2342: END IF;
2343:
2344: ELSE

Line 2341: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);

2337: -- Debug Message
2338: IF (PV_DEBUG_HIGH_ON) THEN
2339: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension call');
2340: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_trxn_extension_id ' || lx_trxn_extension_id);
2341: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' lx_instr_assign_id ' || lx_instr_assign_id);
2342: END IF;
2343:
2344: ELSE
2345: lx_trxn_extension_id := x_enrl_info(x.header_id).trxn_extension_id;

Line 2349: PVX_UTILITY_PVT.debug_message('Checking if credit card is the same and has already been authorized');

2345: lx_trxn_extension_id := x_enrl_info(x.header_id).trxn_extension_id;
2346:
2347: -- Debug Message
2348: IF (PV_DEBUG_HIGH_ON) THEN
2349: PVX_UTILITY_PVT.debug_message('Checking if credit card is the same and has already been authorized');
2350: END IF;
2351:
2352: IF (l_skip_auth = 'N') THEN
2353: select nvl(authorized_flag,'N')

Line 2361: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');

2357: END IF;
2358:
2359: -- Debug Message
2360: IF (PV_DEBUG_HIGH_ON) THEN
2361: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');
2362: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' instrument assignment id = ' || lx_instr_assign_id);
2363: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' skip authorization flag = ' || l_skip_auth);
2364: END IF;
2365:

Line 2362: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' instrument assignment id = ' || lx_instr_assign_id);

2358:
2359: -- Debug Message
2360: IF (PV_DEBUG_HIGH_ON) THEN
2361: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');
2362: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' instrument assignment id = ' || lx_instr_assign_id);
2363: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' skip authorization flag = ' || l_skip_auth);
2364: END IF;
2365:
2366:

Line 2363: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' skip authorization flag = ' || l_skip_auth);

2359: -- Debug Message
2360: IF (PV_DEBUG_HIGH_ON) THEN
2361: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');
2362: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' instrument assignment id = ' || lx_instr_assign_id);
2363: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' skip authorization flag = ' || l_skip_auth);
2364: END IF;
2365:
2366:
2367: -- Only update transaction extension if successful authorization hasn't already happened (online or offline)

Line 2388: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_return_status);

2384: x_response => lx_response
2385: );
2386:
2387: IF (PV_DEBUG_HIGH_ON) THEN
2388: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_return_status);
2389: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_count);
2390: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_data);
2391: END IF;
2392:

Line 2389: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_count);

2385: );
2386:
2387: IF (PV_DEBUG_HIGH_ON) THEN
2388: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_return_status);
2389: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_count);
2390: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_data);
2391: END IF;
2392:
2393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2390: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_data);

2386:
2387: IF (PV_DEBUG_HIGH_ON) THEN
2388: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_return_status);
2389: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_count);
2390: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension : ' || x_msg_data);
2391: END IF;
2392:
2393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2394: IF ((lx_response.Result_Category = 'INVALID_PARAM') or (lx_response.Result_Category = 'INCORRECT_FLOW')) THEN

Line 2406: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');

2402: END IF;
2403:
2404: -- Debug Message
2405: IF (PV_DEBUG_HIGH_ON) THEN
2406: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension call');
2407: END IF;
2408: END IF;
2409:
2410: END IF; -- x_enrl_info(x.header_id).trxn_extension_id IS NULL

Line 2430: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before IBY_FNDCPT_TRXN_PUB.Create_Authorization');

2426: l_auth_attribs.RiskEval_Enable_Flag := 'N';
2427:
2428: -- Debug Message
2429: IF (PV_DEBUG_HIGH_ON) THEN
2430: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before IBY_FNDCPT_TRXN_PUB.Create_Authorization');
2431: PVX_UTILITY_PVT.debug_message('Payee ID (Org ID): ' || l_payee.Org_id);
2432: END IF;
2433:
2434: IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION

Line 2431: PVX_UTILITY_PVT.debug_message('Payee ID (Org ID): ' || l_payee.Org_id);

2427:
2428: -- Debug Message
2429: IF (PV_DEBUG_HIGH_ON) THEN
2430: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before IBY_FNDCPT_TRXN_PUB.Create_Authorization');
2431: PVX_UTILITY_PVT.debug_message('Payee ID (Org ID): ' || l_payee.Org_id);
2432: END IF;
2433:
2434: IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION
2435: (

Line 2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);

2447: x_response => lx_response
2448: );
2449:
2450: IF (PV_DEBUG_HIGH_ON) THEN
2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);
2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);

Line 2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);

2448: );
2449:
2450: IF (PV_DEBUG_HIGH_ON) THEN
2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);
2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);
2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);

Line 2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);

2449:
2450: IF (PV_DEBUG_HIGH_ON) THEN
2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);
2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);
2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);
2457: END IF;

Line 2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);

2450: IF (PV_DEBUG_HIGH_ON) THEN
2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);
2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);
2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);
2457: END IF;
2458:

Line 2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);

2451: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_return_status from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_return_status);
2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);
2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);
2457: END IF;
2458:
2459: /* R12 Changes

Line 2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);

2452: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_count from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_count);
2453: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_msg_data from IBY_FNDCPT_TRXN_PUB.CREATE_AUTHORIZATION : ' || x_msg_data);
2454: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Code: ' || lx_response.Result_Code);
2455: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Category: ' || lx_response.Result_Category);
2456: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' x_response Message: ' || lx_response.Result_Message);
2457: END IF;
2458:
2459: /* R12 Changes
2460: * Even if Authorization is unsuccessful, we do not throw an expection.

Line 2560: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;

2556: lx_enrl_info Payment_info_Tbl_type;
2557: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2558: l_order_header_id_tbl Payment_info_Tbl_type;
2559: l_enrl_req_rec PV_Pg_Enrl_Requests_PVT.enrl_request_rec_type;
2560: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;
2561: l_partner_id number;
2562: l_trans_currency varchar2(15);
2563: l_payment_amount number;
2564: l_pmnt_mode_mean varchar2(80);

Line 2634: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

2630:
2631: -- Debug Message
2632: IF (PV_DEBUG_HIGH_ON) THEN
2633:
2634: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
2635: END IF;
2636:
2637:
2638: -- Initialize API return status to SUCCESS

Line 2682: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before calling set_payment_info ');

2678:
2679:
2680: IF (l_order_header_id_tbl.count >0) THEN
2681: IF (PV_DEBUG_HIGH_ON) THEN
2682: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before calling set_payment_info ');
2683: END IF;
2684:
2685: set_payment_info(
2686: p_api_version_number => p_api_version_number

Line 2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');

2697: ,x_enrl_info => lx_enrl_info
2698: );
2699:
2700: IF (PV_DEBUG_HIGH_ON) THEN
2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');
2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);
2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);
2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);
2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);

Line 2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);

2698: );
2699:
2700: IF (PV_DEBUG_HIGH_ON) THEN
2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');
2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);
2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);
2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);
2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);
2706: END IF;

Line 2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);

2699:
2700: IF (PV_DEBUG_HIGH_ON) THEN
2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');
2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);
2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);
2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);
2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);
2706: END IF;
2707:

Line 2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);

2700: IF (PV_DEBUG_HIGH_ON) THEN
2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');
2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);
2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);
2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);
2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);
2706: END IF;
2707:
2708: END IF;

Line 2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);

2701: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After calling set_payment_info');
2702: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_return_status ' || x_return_status);
2703: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_count ' || x_msg_count);
2704: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_msg_data ' || x_msg_data);
2705: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' x_is_authorized ' || x_is_authorized);
2706: END IF;
2707:
2708: END IF;
2709:

Line 2723: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before update pv_pg_enrl_request');

2719: l_enrl_req_rec.trxn_extension_id := lx_enrl_info(i).trxn_extension_id;
2720:
2721:
2722: IF (PV_DEBUG_HIGH_ON) THEN
2723: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before update pv_pg_enrl_request');
2724: END IF;
2725:
2726: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
2727: (

Line 2739: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After populating trxn_extension_id in pv_pg_enrl_request x_return_status ' || x_return_status);

2735: p_enrl_request_rec => l_enrl_req_rec
2736: );
2737:
2738: IF (PV_DEBUG_HIGH_ON) THEN
2739: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After populating trxn_extension_id in pv_pg_enrl_request x_return_status ' || x_return_status);
2740: END IF;
2741:
2742: IF x_return_status = FND_API.g_ret_sts_error THEN
2743: RAISE FND_API.g_exc_error;

Line 2801: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the OE_ORDER_GRP.process_order call ');

2797: Order_Debug_On;
2798:
2799: -- Debug Message
2800: IF (PV_DEBUG_HIGH_ON) THEN
2801: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the OE_ORDER_GRP.process_order call ');
2802: END IF;
2803:
2804: OE_ORDER_GRP.process_order(
2805: p_api_version_number => l_api_version_number,

Line 2842: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After process_order API call : x_return_status ' || x_return_status);

2838: x_action_request_tbl =>x_action_request_tbl
2839: );
2840:
2841: IF (PV_DEBUG_HIGH_ON) THEN
2842: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After process_order API call : x_return_status ' || x_return_status);
2843: END IF;
2844:
2845: Retrieve_OE_Messages;
2846:

Line 2866: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the OE_ORDER_GRP.process_order call');

2862: END LOOP;
2863:
2864: -- Debug Message
2865: IF (PV_DEBUG_HIGH_ON) THEN
2866: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the OE_ORDER_GRP.process_order call');
2867: END IF;
2868:
2869:
2870: for i in lx_enrl_info.FIRST..lx_enrl_info.LAST loop

Line 2880: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before update pv_pg_enrl_request');

2876: END IF;
2877:
2878:
2879: IF (PV_DEBUG_HIGH_ON) THEN
2880: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Before update pv_pg_enrl_request');
2881: END IF;
2882:
2883: PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
2884: (

Line 2896: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After updating payment status to AUTHORIZED in pv_pg_enrl_request x_return_status ' || x_return_status);

2892: p_enrl_request_rec => l_enrl_req_rec
2893: );
2894:
2895: IF (PV_DEBUG_HIGH_ON) THEN
2896: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| 'After updating payment status to AUTHORIZED in pv_pg_enrl_request x_return_status ' || x_return_status);
2897: END IF;
2898:
2899: IF x_return_status = FND_API.g_ret_sts_error THEN
2900: RAISE FND_API.g_exc_error;

Line 2909: pvx_utility_pvt.create_history_log

2905:
2906: IF (p_payment_method_rec.payment_type_code = 'CREDIT_CARD') THEN
2907: IF (x_is_authorized = 'Y') THEN
2908:
2909: pvx_utility_pvt.create_history_log
2910: (
2911: p_arc_history_for_entity_code => 'ENRQ',
2912: p_history_for_entity_id => lx_enrl_info(i).enrl_req_id,
2913: p_history_category_code => 'PAYMENT',

Line 2924: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After create history log : x_return_status ' || x_return_status);

2920: x_msg_data => x_msg_data
2921: );
2922:
2923: IF (PV_DEBUG_HIGH_ON) THEN
2924: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After create history log : x_return_status ' || x_return_status);
2925: END IF;
2926:
2927: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2928: RAISE FND_API.g_exc_error;

Line 2958: pvx_utility_pvt.create_history_log

2954:
2955: l_log_params_tbl(3).param_name := 'MODE';
2956: l_log_params_tbl(3).param_value := l_pmnt_mode_mean;
2957:
2958: pvx_utility_pvt.create_history_log
2959: (
2960: p_arc_history_for_entity_code => 'ENRQ',
2961: p_history_for_entity_id => lx_enrl_info(i).enrl_req_id,
2962: p_history_category_code => 'PAYMENT',

Line 2973: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After create history log : x_return_status ' || x_return_status);

2969: x_msg_data => x_msg_data
2970: );
2971:
2972: IF (PV_DEBUG_HIGH_ON) THEN
2973: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' After create history log : x_return_status ' || x_return_status);
2974: END IF;
2975:
2976: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2977: RAISE FND_API.g_exc_error;

Line 2986: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Processing done');

2982:
2983: END LOOP;
2984:
2985: IF (PV_DEBUG_HIGH_ON) THEN
2986: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name|| ' Processing done');
2987: END IF;
2988:
2989:
2990: FND_MSG_PUB.Count_And_Get

Line 3119: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

3115: END IF;
3116:
3117: -- Debug Message
3118: IF (PV_DEBUG_HIGH_ON) THEN
3119: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
3120: END IF;
3121:
3122:
3123: -- Initialize API return status to SUCCESS

Line 3242: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the OE_ORDER_GRP.process_order call');

3238: Order_Debug_On;
3239:
3240: -- Debug Message
3241: IF (PV_DEBUG_HIGH_ON) THEN
3242: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' before the OE_ORDER_GRP.process_order call');
3243: END IF;
3244:
3245: OE_ORDER_GRP.process_order(
3246: p_api_version_number => l_api_version_number,

Line 3300: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the OE_ORDER_GRP.process_order call');

3296: END IF;
3297:
3298: -- Debug Message
3299: IF (PV_DEBUG_HIGH_ON) THEN
3300: PVX_UTILITY_PVT.debug_message('In ' || l_api_name || ' after the OE_ORDER_GRP.process_order call');
3301: END IF;
3302:
3303: END LOOP;
3304: