eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PARTNER_PROGRAM_PVT dependencies on PVX_UTILITY_PVT

Line 52: -- PVX_UTILITY_PVT.debug_message('l_new_inv_item_id(.....

48: -- 12/08/2003 ktsao Made a call to copy the program prerequisites in Copy_Qualifications().
49: -- 12/08/2003 ktsao Changed package name from AMS_PRICELIST_PVT to OZF_PRICELIST_PVT.
50: -- 12/09/2003 ktsao Modified Copy_Qualifications to copy the prereq process rules as well.
51: -- 12/11/2003 ktsao Switch the order of
52: -- PVX_UTILITY_PVT.debug_message('l_new_inv_item_id(.....
53: -- and
54: -- l_index := l_index + 1;
55: -- in Copy_Payments().
56: -- 04/11/2005 ktsao Code changes for create_inv_item_if_not_exists

Line 498: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('l_ptr_prgm_rec.no_fee_flag ' || l_ptr_prgm_rec.no_fee_flag); END IF;

494: l_pricing_attr_tbl(1).PRICE_LIST_LINE_index :=1;
495: l_pricing_attr_tbl(1).product_uom_code := l_uom_code;
496:
497: -- -- dbms_output.put_line('l_ptr_prgm_rec.no_fee_flag ' || l_ptr_prgm_rec.no_fee_flag);
498: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('l_ptr_prgm_rec.no_fee_flag ' || l_ptr_prgm_rec.no_fee_flag); END IF;
499:
500:
501:
502: if (p_operation = QP_GLOBALS.G_OPR_UPDATE) THEN

Line 553: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_return_status : ' || l_return_status);

549:
550: -- dbms_output.put_line('IN UPDATE BLOCK : l_return_status : ' || l_return_status);
551: IF (PV_DEBUG_HIGH_ON) THEN
552:
553: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_return_status : ' || l_return_status);
554: END IF;
555:
556: -- dbms_output.put_line('IN UPDATE BLOCK : l_msg_count : ' || l_msg_count);
557: IF (PV_DEBUG_HIGH_ON) THEN

Line 559: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_msg_count : ' || l_msg_count);

555:
556: -- dbms_output.put_line('IN UPDATE BLOCK : l_msg_count : ' || l_msg_count);
557: IF (PV_DEBUG_HIGH_ON) THEN
558:
559: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_msg_count : ' || l_msg_count);
560: END IF;
561:
562: -- dbms_output.put_line('IN UPDATE BLOCK : l_msg_data : ' || l_msg_data);
563: IF (PV_DEBUG_HIGH_ON) THEN

Line 565: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_msg_data : ' || l_msg_data);

561:
562: -- dbms_output.put_line('IN UPDATE BLOCK : l_msg_data : ' || l_msg_data);
563: IF (PV_DEBUG_HIGH_ON) THEN
564:
565: PVX_UTILITY_PVT.debug_message('IN UPDATE BLOCK : l_msg_data : ' || l_msg_data);
566: END IF;
567:
568:
569: ELSE

Line 609: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_return_status : ' || l_return_status);

605:
606: -- dbms_output.put_line('IN CREATE BLOCK : l_return_status : ' || l_return_status);
607: IF (PV_DEBUG_HIGH_ON) THEN
608:
609: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_return_status : ' || l_return_status);
610: END IF;
611:
612: -- dbms_output.put_line('IN CREATE BLOCK : l_msg_count : ' || l_msg_count);
613: IF (PV_DEBUG_HIGH_ON) THEN

Line 615: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_msg_count : ' || l_msg_count);

611:
612: -- dbms_output.put_line('IN CREATE BLOCK : l_msg_count : ' || l_msg_count);
613: IF (PV_DEBUG_HIGH_ON) THEN
614:
615: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_msg_count : ' || l_msg_count);
616: END IF;
617:
618: -- dbms_output.put_line('IN CREATE BLOCK : l_msg_data : ' || l_msg_data);
619: IF (PV_DEBUG_HIGH_ON) THEN

Line 621: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_msg_data : ' || l_msg_data);

617:
618: -- dbms_output.put_line('IN CREATE BLOCK : l_msg_data : ' || l_msg_data);
619: IF (PV_DEBUG_HIGH_ON) THEN
620:
621: PVX_UTILITY_PVT.debug_message('IN CREATE BLOCK : l_msg_data : ' || l_msg_data);
622: END IF;
623:
624: -- Standard call to get message count and if count=1, get the message
625: -- OE_MSG_PUB.Count_And_Get (

Line 635: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;

631: -- FOR i IN 1 .. l_count LOOP
632: -- l_msg := OE_MSG_PUB.get(i, FND_API.g_false);
633: -- -- holiu: remove since adchkdrv does not like it
634: -- -- dbms_OUTPUT.put_line('( IN CREATE BLOCK :' || i || ') ' || l_msg);
635: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;
636: -- END LOOP;
637: END IF;
638:
639:

Line 648: PVX_UTILITY_PVT.debug_message('111 The x_pricelist_line_id is : '||v_PRICE_LIST_LINE_tbl(1).list_line_id);

644: --
645: -- dbms_output.put_line('111 The x_pricelist_line_id is : '||v_PRICE_LIST_LINE_tbl(1).list_line_id);
646: IF (PV_DEBUG_HIGH_ON) THEN
647:
648: PVX_UTILITY_PVT.debug_message('111 The x_pricelist_line_id is : '||v_PRICE_LIST_LINE_tbl(1).list_line_id);
649: END IF;
650:
651: -- dbms_output.put_line('l_msg_count '|| l_msg_count);
652: IF (PV_DEBUG_HIGH_ON) THEN

Line 654: PVX_UTILITY_PVT.debug_message('l_msg_count '|| l_msg_count);

650:
651: -- dbms_output.put_line('l_msg_count '|| l_msg_count);
652: IF (PV_DEBUG_HIGH_ON) THEN
653:
654: PVX_UTILITY_PVT.debug_message('l_msg_count '|| l_msg_count);
655: END IF;
656:
657: -- dbms_output.put_line('l_msg_data '|| l_msg_data);
658: IF (PV_DEBUG_HIGH_ON) THEN

Line 660: PVX_UTILITY_PVT.debug_message('l_msg_data '|| l_msg_data);

656:
657: -- dbms_output.put_line('l_msg_data '|| l_msg_data);
658: IF (PV_DEBUG_HIGH_ON) THEN
659:
660: PVX_UTILITY_PVT.debug_message('l_msg_data '|| l_msg_data);
661: END IF;
662:
663:
664: -- l_count := OE_MSG_PUB.count_msg;

Line 669: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;

665: -- FOR i IN 1 .. l_count LOOP
666: -- l_msg := OE_MSG_PUB.get(i, FND_API.g_false);
667: -- -- holiu: remove since adchkdrv does not like it
668: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
669: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;
670: -- END LOOP;
671:
672: -- dbms_output.put_line('Printing Error Messages from FND');
673: --

Line 702: PVX_UTILITY_PVT.debug_message('In CREATE_PRICE_LINE API ERROR BLOCK');

698: IF (PV_DEBUG_HIGH_ON) THEN
699:
700:
701:
702: PVX_UTILITY_PVT.debug_message('In CREATE_PRICE_LINE API ERROR BLOCK');
703:
704: END IF;
705:
706: -- Standard call to get message count and if count=1, get the message

Line 717: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;

713: -- FOR i IN 1 .. l_count LOOP
714: -- l_msg := OE_MSG_PUB.get(i, FND_API.g_false);
715: -- -- holiu: remove since adchkdrv does not like it
716: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
717: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;
718: -- END LOOP;
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1057:
1058: -- Debug Message
1059: IF (PV_DEBUG_HIGH_ON) THEN
1060:
1061: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
1062: END IF;
1063:
1064:
1065: -- Initialize API return status to SUCCESS

Line 1120: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - get process_rule_id');

1116: -- Create and get process_rule_id
1117: -- Debug message
1118: IF (PV_DEBUG_HIGH_ON) THEN
1119:
1120: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - get process_rule_id');
1121: END IF;
1122:
1123: -- Populate the default required items for process_rule_id
1124: l_rules_rec.process_type := 'PARTNER_PROGRAM';

Line 1169: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );

1165:
1166: -- Debug message
1167: IF (PV_DEBUG_HIGH_ON) THEN
1168:
1169: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );
1170: END IF;
1171: -- End of call to PV_PROCESS_RULES_PUB.Create_Process_Rules
1172:
1173: -- Invoke prereq_process_rule_Id api

Line 1196: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );

1192: RAISE FND_API.g_exc_unexpected_error;
1193: END IF;
1194:
1195: IF (PV_DEBUG_HIGH_ON) THEN
1196: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );
1197: END IF;
1198:
1199:
1200: -- Debug message

Line 1203: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_id = '|| l_ptr_prgm_rec.program_id);

1199:
1200: -- Debug message
1201: IF (PV_DEBUG_HIGH_ON) THEN
1202:
1203: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_id = '|| l_ptr_prgm_rec.program_id);
1204: END IF;
1205:
1206: -- Populate the default required items
1207: l_ptr_prgm_rec.last_update_date := SYSDATE;

Line 1218: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Partner_Program');

1214: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1215: -- Debug message
1216: IF (PV_DEBUG_HIGH_ON) THEN
1217:
1218: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Partner_Program');
1219: END IF;
1220:
1221: -- populate enabled flag only if value not passed from application
1222: IF l_ptr_prgm_rec.enabled_flag = FND_API.g_miss_char THEN

Line 1241: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Partner_Program return_status = ' || x_return_status );

1237: );
1238: -- Debug message
1239: IF (PV_DEBUG_HIGH_ON) THEN
1240:
1241: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Partner_Program return_status = ' || x_return_status );
1242: END IF;
1243:
1244: END IF;
1245:

Line 1263: PVX_UTILITY_PVT.debug_message('Owner Resource Id : ' || l_ptr_prgm_rec.program_owner_resource_id);

1259: l_access_rec.admin_flag := 'N' ;
1260:
1261:
1262: IF (PV_DEBUG_HIGH_ON) THEN
1263: PVX_UTILITY_PVT.debug_message('Owner Resource Id : ' || l_ptr_prgm_rec.program_owner_resource_id);
1264: END IF;
1265:
1266: IF (PV_DEBUG_HIGH_ON) THEN
1267:

Line 1268: PVX_UTILITY_PVT.debug_message('p_identity_resource_id : ' || p_identity_resource_id);

1264: END IF;
1265:
1266: IF (PV_DEBUG_HIGH_ON) THEN
1267:
1268: PVX_UTILITY_PVT.debug_message('p_identity_resource_id : ' || p_identity_resource_id);
1269: END IF;
1270:
1271: IF ( l_ptr_prgm_rec.program_owner_resource_id <> p_identity_resource_id ) then
1272:

Line 1275: PVX_UTILITY_PVT.debug_message('Adding Owner To the Team');

1271: IF ( l_ptr_prgm_rec.program_owner_resource_id <> p_identity_resource_id ) then
1272:
1273:
1274: IF (PV_DEBUG_HIGH_ON) THEN
1275: PVX_UTILITY_PVT.debug_message('Adding Owner To the Team');
1276: END IF;
1277: l_access_rec.user_or_role_id := l_ptr_prgm_rec.program_owner_resource_id;
1278: l_access_rec.owner_flag := 'Y' ;
1279:

Line 1295: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);

1291: x_access_id => l_dummy_id
1292: );
1293:
1294: IF (PV_DEBUG_HIGH_ON) THEN
1295: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);
1296: END IF;
1297: IF (PV_DEBUG_HIGH_ON) THEN
1298: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);
1299: END IF;

Line 1298: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);

1294: IF (PV_DEBUG_HIGH_ON) THEN
1295: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);
1296: END IF;
1297: IF (PV_DEBUG_HIGH_ON) THEN
1298: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);
1299: END IF;
1300:
1301: IF x_return_status = FND_API.g_ret_sts_error THEN
1302: RAISE FND_API.g_exc_error;

Line 1308: PVX_UTILITY_PVT.debug_message('Adding Creator To the Team');

1304: RAISE FND_API.g_exc_unexpected_error;
1305: END IF;
1306:
1307: IF (PV_DEBUG_HIGH_ON) THEN
1308: PVX_UTILITY_PVT.debug_message('Adding Creator To the Team');
1309: END IF;
1310: /*** Adding Creator to the Team ***/
1311: l_access_rec.user_or_role_id := p_identity_resource_id;
1312: l_access_rec.owner_flag := 'N' ;

Line 1329: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding creator ' || x_return_status);

1325: x_access_id => l_dummy_id
1326: );
1327:
1328: IF (PV_DEBUG_HIGH_ON) THEN
1329: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding creator ' || x_return_status);
1330: END IF;
1331: IF (PV_DEBUG_HIGH_ON) THEN
1332: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding creator ' || l_dummy_id);
1333: END IF;

Line 1332: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding creator ' || l_dummy_id);

1328: IF (PV_DEBUG_HIGH_ON) THEN
1329: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding creator ' || x_return_status);
1330: END IF;
1331: IF (PV_DEBUG_HIGH_ON) THEN
1332: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding creator ' || l_dummy_id);
1333: END IF;
1334:
1335: IF x_return_status = FND_API.g_ret_sts_error THEN
1336: RAISE FND_API.g_exc_error;

Line 1345: PVX_UTILITY_PVT.debug_message('Adding Owner To the Team');

1341:
1342:
1343: ELSE
1344: IF (PV_DEBUG_HIGH_ON) THEN
1345: PVX_UTILITY_PVT.debug_message('Adding Owner To the Team');
1346: END IF;
1347: l_access_rec.user_or_role_id := l_ptr_prgm_rec.program_owner_resource_id;
1348: l_access_rec.owner_flag := 'Y' ;
1349:

Line 1366: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);

1362: );
1363:
1364:
1365: IF (PV_DEBUG_HIGH_ON) THEN
1366: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);
1367: END IF;
1368: IF (PV_DEBUG_HIGH_ON) THEN
1369: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);
1370: END IF;

Line 1369: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);

1365: IF (PV_DEBUG_HIGH_ON) THEN
1366: PVX_UTILITY_PVT.debug_message('Return Status From Access API after adding owner ' || x_return_status);
1367: END IF;
1368: IF (PV_DEBUG_HIGH_ON) THEN
1369: PVX_UTILITY_PVT.debug_message('Access ID From Access API after adding owner' || l_dummy_id);
1370: END IF;
1371:
1372: IF x_return_status = FND_API.g_ret_sts_error THEN
1373: RAISE FND_API.g_exc_error;

Line 1420: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_full_name || ' - Calling create table handler');

1416: END IF;
1417: -- Debug Message
1418: IF (PV_DEBUG_HIGH_ON) THEN
1419:
1420: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_full_name || ' - Calling create table handler');
1421: END IF;
1422:
1423: -- Invoke table handler(PV_PARTNER_PROGRAM_PKG.Insert_Row)
1424: PV_PARTNER_PROGRAM_PKG.Insert_Row(

Line 1491: PVX_UTILITY_PVT.debug_message('The program id created ' || x_program_id);

1487: -- dbms_output.put_line('The program id created ' || x_program_id);
1488: -- Debug Message
1489: IF (PV_DEBUG_HIGH_ON) THEN
1490:
1491: PVX_UTILITY_PVT.debug_message('The program id created ' || x_program_id);
1492: END IF;
1493:
1494:
1495: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 1532: PVX_UTILITY_PVT.debug_message('PV_AUTO_CREATION_OF_INVENTORY is not N');

1528: -- If the profile is not set or set to 'Y'
1529: IF (((FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') is null) or (FND_PROFILE.VALUE('PV_ENABLE_AUTO_CREATION_OF_INVENTORY_ITEM') = 'Y')) and
1530: l_ptr_prgm_rec.no_fee_flag = 'N') THEN
1531: IF (PV_DEBUG_HIGH_ON) THEN
1532: PVX_UTILITY_PVT.debug_message('PV_AUTO_CREATION_OF_INVENTORY is not N');
1533: END IF;
1534:
1535: IF l_ptr_prgm_rec.program_level_code = 'MEMBERSHIP' THEN
1536: create_inventory_item(

Line 1565: PVX_UTILITY_PVT.debug_message(' Calling Update_Partner_Program');

1561:
1562:
1563:
1564:
1565: PVX_UTILITY_PVT.debug_message(' Calling Update_Partner_Program');
1566:
1567:
1568: END IF;
1569:

Line 1638: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

1634:
1635: -- Debug Message
1636: IF (PV_DEBUG_HIGH_ON) THEN
1637:
1638: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
1639: END IF;
1640:
1641: -- Standard check for p_commit
1642: IF FND_API.to_Boolean( p_commit ) THEN

Line 1657: PVX_UTILITY_PVT.debug_message('In CREATE_PARTNER_PROGRAM API ERROR BLOCK');

1653: IF (PV_DEBUG_HIGH_ON) THEN
1654:
1655:
1656:
1657: PVX_UTILITY_PVT.debug_message('In CREATE_PARTNER_PROGRAM API ERROR BLOCK');
1658:
1659: END IF;
1660:
1661: -- Standard call to get message count and if count=1, get the message

Line 1673: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;

1669: -- FOR i IN 1 .. l_count LOOP
1670: -- l_msg := OE_MSG_PUB.get(i, FND_API.g_false);
1671: -- -- holiu: remove since adchkdrv does not like it
1672: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
1673: -- IF (PV_DEBUG_HIGH_ON) THEN PVX_UTILITY_PVT.debug_message('(' || i || ') ' || l_msg); END IF;
1674: -- END LOOP;
1675:
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK TO CREATE_Partner_Program_PVT;

Line 1766: PVX_UTILITY_PVT.debug_message(' in Update_Partner_Program');

1762:
1763: -- dbms_output.put_line(' in Update_Partner_Program');
1764: IF (PV_DEBUG_HIGH_ON) THEN
1765:
1766: PVX_UTILITY_PVT.debug_message(' in Update_Partner_Program');
1767: END IF;
1768:
1769: ---------Initialize ------------------
1770: get_program_status_code(l_tar_ptr_prgm_rec.user_status_id,l_tar_ptr_prgm_rec.program_status_code,x_return_status);

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

1774:
1775: -- Debug Message
1776: IF (PV_DEBUG_HIGH_ON) THEN
1777:
1778: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
1779: END IF;
1780:
1781: -- Standard call to check for call compatibility.
1782: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 1803: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

1799:
1800: -- Debug Message
1801: IF (PV_DEBUG_HIGH_ON) THEN
1802:
1803: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
1804: END IF;
1805:
1806: OPEN c_get_Partner_Program( l_tar_ptr_prgm_rec.program_id);
1807: FETCH c_get_Partner_Program INTO l_ref_ptr_prgm_rec ;

Line 1821: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');

1817:
1818: -- Debug Message
1819: IF (PV_DEBUG_HIGH_ON) THEN
1820:
1821: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');
1822: END IF;
1823: CLOSE c_get_Partner_Program;
1824:
1825: IF (l_tar_ptr_prgm_rec.object_version_number IS NULL OR

Line 1846: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Partner_Program');

1842: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1843: -- Debug message
1844: IF (PV_DEBUG_HIGH_ON) THEN
1845:
1846: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Partner_Program');
1847: END IF;
1848:
1849:
1850: -- Invoke validation procedures

Line 2020: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');

2016:
2017: -- Debug Message
2018: IF (PV_DEBUG_HIGH_ON) THEN
2019:
2020: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
2021: END IF;
2022:
2023: -- Invoke table handler(PV_PARTNER_PROGRAM_PKG.Update_Row)
2024: PV_PARTNER_PROGRAM_PKG.Update_Row(

Line 2118: PVX_UTILITY_PVT.debug_message('Private: ' || l_api_name || 'Inside if when status is moved to planned');

2114: end loop;
2115: END IF;
2116: IF (PV_DEBUG_HIGH_ON) THEN
2117:
2118: PVX_UTILITY_PVT.debug_message('Private: ' || l_api_name || 'Inside if when status is moved to planned');
2119: END IF;
2120: IF (l_tar_ptr_prgm_rec.program_parent_id is not null) and (l_tar_ptr_prgm_rec.program_parent_id <> FND_API.g_miss_num) THEN
2121: l_is_parent_approved:=isParentApproved(l_tar_ptr_prgm_rec.program_parent_id);
2122: IF l_is_parent_approved=false THEN

Line 2135: PVX_UTILITY_PVT.debug_message('Private: ' || l_api_name || 'Just before calling start process');

2131: l_valid_approvers:=isApproverExists(l_tar_ptr_prgm_rec.PROGRAM_TYPE_ID);
2132: IF l_valid_approvers=true THEN
2133: IF (PV_DEBUG_HIGH_ON) THEN
2134:
2135: PVX_UTILITY_PVT.debug_message('Private: ' || l_api_name || 'Just before calling start process');
2136: END IF;
2137: open c_get_status_code('NEW');
2138: fetch c_get_status_code into l_user_status_for_new;
2139: IF ( c_get_status_code%NOTFOUND) THEN

Line 2198: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

2194:
2195: -- Debug Message
2196: IF (PV_DEBUG_HIGH_ON) THEN
2197:
2198: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2199: END IF;
2200:
2201: EXCEPTION
2202: WHEN FND_API.G_EXC_ERROR THEN

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

2277:
2278: -- Debug Message
2279: IF (PV_DEBUG_HIGH_ON) THEN
2280:
2281: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
2282: END IF;
2283:
2284: -- Standard call to check for call compatibility.
2285: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 2306: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - checking for object_version_number = ' || p_object_version_number);

2302:
2303: -- Debug Message
2304: IF (PV_DEBUG_HIGH_ON) THEN
2305:
2306: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - checking for object_version_number = ' || p_object_version_number);
2307: END IF;
2308: IF (p_object_version_number is NULL or
2309: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2310:

Line 2338: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');

2334:
2335: -- Debug Message
2336: IF (PV_DEBUG_HIGH_ON) THEN
2337:
2338: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');
2339: END IF;
2340: CLOSE c_get_partner_program_rec;
2341:
2342: IF (l_tar_ptr_prgm_rec.object_version_number is NULL or

Line 2374: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');

2370:
2371: -- Debug Message
2372: IF (PV_DEBUG_HIGH_ON) THEN
2373:
2374: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');
2375: END IF;
2376:
2377: -- Invoke table handler(PV_PARTNER_PROGRAM_PKG.Delete_Row)
2378: PV_PARTNER_PROGRAM_PKG.Delete_Row(

Line 2397: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

2393:
2394: -- Debug Message
2395: IF (PV_DEBUG_HIGH_ON) THEN
2396:
2397: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2398: END IF;
2399:
2400: EXCEPTION
2401: WHEN FND_API.G_EXC_ERROR THEN

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

2465:
2466: -- Debug Message
2467: IF (PV_DEBUG_HIGH_ON) THEN
2468:
2469: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
2470: END IF;
2471:
2472: -- Initialize message list if p_init_msg_list is set to TRUE.
2473: IF FND_API.to_Boolean( p_init_msg_list )

Line 2520: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

2516:
2517: -- Debug Message
2518: IF (PV_DEBUG_HIGH_ON) THEN
2519:
2520: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2521: END IF;
2522:
2523: EXCEPTION
2524: /*

Line 2525: WHEN PVX_UTILITY_PVT.resource_locked THEN

2521: END IF;
2522:
2523: EXCEPTION
2524: /*
2525: WHEN PVX_UTILITY_PVT.resource_locked THEN
2526: x_return_status := FND_API.g_ret_sts_error;
2527: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2528: */
2529: WHEN FND_API.G_EXC_ERROR THEN

Line 2527: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2523: EXCEPTION
2524: /*
2525: WHEN PVX_UTILITY_PVT.resource_locked THEN
2526: x_return_status := FND_API.g_ret_sts_error;
2527: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2528: */
2529: WHEN FND_API.G_EXC_ERROR THEN
2530: ROLLBACK TO LOCK_Partner_Program_PVT;
2531: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2581: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

2577:
2578: x_return_status := FND_API.g_ret_sts_success;
2579: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2580:
2581: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2582: 'PV_PARTNER_PROGRAM_B',
2583: 'PROGRAM_ID = ''' || p_ptr_prgm_rec.PROGRAM_ID ||''''
2584: );
2585:

Line 2597: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before Process_Rule_ID check' );

2593: END IF;
2594: -- Debug message
2595: IF (PV_DEBUG_HIGH_ON) THEN
2596:
2597: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before Process_Rule_ID check' );
2598: END IF;
2599:
2600:
2601: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 2601: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

2597: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before Process_Rule_ID check' );
2598: END IF;
2599:
2600:
2601: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2602: 'PV_PARTNER_PROGRAM_B',
2603: 'PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PROCESS_RULE_ID ||''''
2604: );
2605:

Line 2618: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before prereq_process_rule_Id check' );

2614:
2615: -- Debug message
2616: IF (PV_DEBUG_HIGH_ON) THEN
2617:
2618: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before prereq_process_rule_Id check' );
2619: END IF;
2620:
2621: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2622: 'PV_PARTNER_PROGRAM_B',

Line 2621: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

2617:
2618: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before prereq_process_rule_Id check' );
2619: END IF;
2620:
2621: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2622: 'PV_PARTNER_PROGRAM_B',
2623: 'PREREQ_PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID ||''''
2624: );
2625:

Line 2718: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before End Date Check' );

2714: END IF;
2715: -- Debug message
2716: IF (PV_DEBUG_HIGH_ON) THEN
2717:
2718: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before End Date Check' );
2719: END IF;
2720:
2721:
2722: IF p_ptr_prgm_rec.program_end_date = FND_API.g_miss_date

Line 2829: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before Created_by Check' );

2825:
2826: -- Debug message
2827: IF (PV_DEBUG_HIGH_ON) THEN
2828:
2829: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before Created_by Check' );
2830: END IF;
2831:
2832:
2833: IF p_ptr_prgm_rec.created_by = FND_API.g_miss_num

Line 3013: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_ptr_prgm_rec.PROGRAM_TYPE_ID);

3009:
3010: -- Debug message
3011: IF (PV_DEBUG_HIGH_ON) THEN
3012:
3013: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_ptr_prgm_rec.PROGRAM_TYPE_ID);
3014: END IF;
3015:
3016: IF PVX_Utility_PVT.check_fk_exists(
3017: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key

Line 3016: IF PVX_Utility_PVT.check_fk_exists(

3012:
3013: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_ptr_prgm_rec.PROGRAM_TYPE_ID);
3014: END IF;
3015:
3016: IF PVX_Utility_PVT.check_fk_exists(
3017: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key
3018: 'PROGRAM_TYPE_ID', -- Column name in the parent object that maps to the fk value
3019: p_ptr_prgm_rec.PROGRAM_TYPE_ID, -- Value of fk to be validated against the parent object's pk column
3020: PVX_utility_PVT.g_number, -- datatype of fk

Line 3020: PVX_utility_PVT.g_number, -- datatype of fk

3016: IF PVX_Utility_PVT.check_fk_exists(
3017: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key
3018: 'PROGRAM_TYPE_ID', -- Column name in the parent object that maps to the fk value
3019: p_ptr_prgm_rec.PROGRAM_TYPE_ID, -- Value of fk to be validated against the parent object's pk column
3020: PVX_utility_PVT.g_number, -- datatype of fk
3021: ' ENABLED_FLAG = ''Y''' || ' AND ACTIVE_FLAG = ''Y'''
3022: ) = FND_API.g_false
3023: THEN
3024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 3038: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items after PROGRAM_TYPE_ID FK check ');

3034:
3035: -- Debug message
3036: IF (PV_DEBUG_HIGH_ON) THEN
3037:
3038: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items after PROGRAM_TYPE_ID FK check ');
3039: END IF;
3040:
3041:
3042: ----------------------- CUSTOM_SETUP_ID ------------------------

Line 3049: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before CUSTOM_SETUP_ID fk check : CUSTOM_SETUP_ID = ' || p_ptr_prgm_rec.CUSTOM_SETUP_ID);

3045:
3046: -- Debug message
3047: IF (PV_DEBUG_HIGH_ON) THEN
3048:
3049: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before CUSTOM_SETUP_ID fk check : CUSTOM_SETUP_ID = ' || p_ptr_prgm_rec.CUSTOM_SETUP_ID);
3050: END IF;
3051:
3052: IF PVX_Utility_PVT.check_fk_exists(
3053: 'AMS_CUSTOM_SETUPS_VL', -- Parent schema object having the primary key

Line 3052: IF PVX_Utility_PVT.check_fk_exists(

3048:
3049: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before CUSTOM_SETUP_ID fk check : CUSTOM_SETUP_ID = ' || p_ptr_prgm_rec.CUSTOM_SETUP_ID);
3050: END IF;
3051:
3052: IF PVX_Utility_PVT.check_fk_exists(
3053: 'AMS_CUSTOM_SETUPS_VL', -- Parent schema object having the primary key
3054: 'CUSTOM_SETUP_ID', -- Column name in the parent object that maps to the fk value
3055: p_ptr_prgm_rec.custom_setup_id, -- Value of fk to be validated against the parent object's pk column
3056: PVX_utility_PVT.g_number, -- datatype of fk

Line 3056: PVX_utility_PVT.g_number, -- datatype of fk

3052: IF PVX_Utility_PVT.check_fk_exists(
3053: 'AMS_CUSTOM_SETUPS_VL', -- Parent schema object having the primary key
3054: 'CUSTOM_SETUP_ID', -- Column name in the parent object that maps to the fk value
3055: p_ptr_prgm_rec.custom_setup_id, -- Value of fk to be validated against the parent object's pk column
3056: PVX_utility_PVT.g_number, -- datatype of fk
3057: ' ENABLED_FLAG = ''Y''' || ' AND OBJECT_TYPE = ''PRGM'''
3058: ) = FND_API.g_false
3059: THEN
3060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 3074: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : After CUSTOM_SETUP_ID fk check ');

3070:
3071: -- Debug message
3072: IF (PV_DEBUG_HIGH_ON) THEN
3073:
3074: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : After CUSTOM_SETUP_ID fk check ');
3075: END IF;
3076:
3077:
3078: ----------------------- PROGRAM_PARENT_ID ------------------------

Line 3083: IF PVX_Utility_PVT.check_fk_exists(

3079: IF (p_ptr_prgm_rec.PROGRAM_PARENT_ID <> FND_API.g_miss_num and
3080: p_ptr_prgm_rec.PROGRAM_PARENT_ID IS NOT NULL ) THEN
3081:
3082:
3083: IF PVX_Utility_PVT.check_fk_exists(
3084: 'PV_PARTNER_PROGRAM_VL', -- Parent schema object having the primary key
3085: 'PROGRAM_ID', -- Column name in the parent object that maps to the fk value
3086: p_ptr_prgm_rec.PROGRAM_PARENT_ID, -- Value of fk to be validated against the parent object's pk column
3087: PVX_utility_PVT.g_number, -- datatype of fk

Line 3087: PVX_utility_PVT.g_number, -- datatype of fk

3083: IF PVX_Utility_PVT.check_fk_exists(
3084: 'PV_PARTNER_PROGRAM_VL', -- Parent schema object having the primary key
3085: 'PROGRAM_ID', -- Column name in the parent object that maps to the fk value
3086: p_ptr_prgm_rec.PROGRAM_PARENT_ID, -- Value of fk to be validated against the parent object's pk column
3087: PVX_utility_PVT.g_number, -- datatype of fk
3088: ' ENABLED_FLAG = ''Y'''
3089: ) = FND_API.g_false
3090: THEN
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 3122: IF PVX_Utility_PVT.check_lookup_exists(

3118:
3119: ----------------------- PROGRAM_LEVEL_CODE LOOKUP ------------------------
3120: IF p_ptr_prgm_rec.program_level_code <> FND_API.g_miss_char THEN
3121:
3122: IF PVX_Utility_PVT.check_lookup_exists(
3123: 'PV_LOOKUPS', -- Look up Table Name
3124: 'PV_PROGRAM_LEVEL', -- Lookup Type
3125: p_ptr_prgm_rec.program_level_code -- Lookup Code
3126: ) = FND_API.g_false

Line 3141: PVX_UTILITY_PVT.debug_message('- In Check_Lookup_Items : After program_level_code lookup check. x_return_status = '||x_return_status);

3137: END IF;
3138: -- Debug message
3139: IF (PV_DEBUG_HIGH_ON) THEN
3140:
3141: PVX_UTILITY_PVT.debug_message('- In Check_Lookup_Items : After program_level_code lookup check. x_return_status = '||x_return_status);
3142: END IF;
3143:
3144: ----------------------- MEMBERSHIP_PERIOD_UNIT ------------------------
3145: IF p_ptr_prgm_rec.membership_period_unit <> FND_API.g_miss_char THEN

Line 3147: IF PVX_Utility_PVT.check_lookup_exists(

3143:
3144: ----------------------- MEMBERSHIP_PERIOD_UNIT ------------------------
3145: IF p_ptr_prgm_rec.membership_period_unit <> FND_API.g_miss_char THEN
3146:
3147: IF PVX_Utility_PVT.check_lookup_exists(
3148: 'PV_LOOKUPS', -- Look up Table Name
3149: 'PV_PRGM_PMNT_UNIT', -- Lookup Type
3150: p_ptr_prgm_rec.membership_period_unit -- Lookup Code
3151: ) = FND_API.g_false

Line 3167: IF PVX_Utility_PVT.check_lookup_exists(

3163:
3164: ----------------------- program_status_code ------------------------
3165: IF p_ptr_prgm_rec.program_status_code <> FND_API.g_miss_char THEN
3166:
3167: IF PVX_Utility_PVT.check_lookup_exists(
3168: 'PV_LOOKUPS', -- Look up Table Name
3169: 'PV_PROGRAM_STATUS', -- Lookup Type
3170: p_ptr_prgm_rec.program_status_code -- Lookup Code
3171: ) = FND_API.g_false

Line 3204: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');

3200:
3201: -- Debug message
3202: IF (PV_DEBUG_HIGH_ON) THEN
3203:
3204: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');
3205: END IF;
3206:
3207: -- Check Items Required/NOT NULL API calls
3208: Check_Req_Items(

Line 3217: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);

3213:
3214: -- Debug message
3215: IF (PV_DEBUG_HIGH_ON) THEN
3216:
3217: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);
3218: END IF;
3219:
3220: IF x_return_status <> FND_API.g_ret_sts_success THEN
3221: RETURN;

Line 3227: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');

3223:
3224: -- Debug message
3225: IF (PV_DEBUG_HIGH_ON) THEN
3226:
3227: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');
3228: END IF;
3229:
3230: -- Check Items Uniqueness API calls
3231: Check_UK_Items(

Line 3240: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);

3236:
3237: -- Debug message
3238: IF (PV_DEBUG_HIGH_ON) THEN
3239:
3240: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);
3241: END IF;
3242:
3243: IF x_return_status <> FND_API.g_ret_sts_success THEN
3244: RETURN;

Line 3250: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');

3246:
3247: -- Debug message
3248: IF (PV_DEBUG_HIGH_ON) THEN
3249:
3250: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');
3251: END IF;
3252:
3253: -- Check Items Foreign Keys API calls
3254: Check_FK_Items(

Line 3262: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);

3258:
3259: -- Debug message
3260: IF (PV_DEBUG_HIGH_ON) THEN
3261:
3262: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);
3263: END IF;
3264:
3265: IF x_return_status <> FND_API.g_ret_sts_success THEN
3266: RETURN;

Line 3272: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');

3268:
3269: -- Debug message
3270: IF (PV_DEBUG_HIGH_ON) THEN
3271:
3272: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');
3273: END IF;
3274:
3275: -- Check Items Lookups
3276: Check_Lookup_Items(

Line 3284: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);

3280:
3281: -- Debug message
3282: IF (PV_DEBUG_HIGH_ON) THEN
3283:
3284: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);
3285: END IF;
3286:
3287: IF x_return_status <> FND_API.g_ret_sts_success THEN
3288: RETURN;

Line 3320: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_id');

3316:
3317: -- Debug message
3318: IF (PV_DEBUG_HIGH_ON) THEN
3319:
3320: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_id');
3321: END IF;
3322:
3323: -- program_id
3324: -- IF p_ptr_prgm_rec.program_id = FND_API.g_miss_num THEN

Line 3357: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_parent_id');

3353:
3354: -- Debug message
3355: IF (PV_DEBUG_HIGH_ON) THEN
3356:
3357: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_parent_id');
3358: END IF;
3359:
3360: -- program_parent_id
3361: IF p_ptr_prgm_rec.program_parent_id IS NULL THEN

Line 3634: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');

3630:
3631: -- Debug Message
3632: IF (PV_DEBUG_HIGH_ON) THEN
3633:
3634: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');
3635: END IF;
3636:
3637: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3638: -- Debug message

Line 3641: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');

3637: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3638: -- Debug message
3639: IF (PV_DEBUG_HIGH_ON) THEN
3640:
3641: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');
3642: END IF;
3643:
3644: Check_Items(
3645: p_ptr_prgm_rec => p_ptr_prgm_rec

Line 3653: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);

3649:
3650: -- Debug message
3651: IF (PV_DEBUG_HIGH_ON) THEN
3652:
3653: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);
3654: END IF;
3655:
3656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3657: RAISE FND_API.G_EXC_ERROR;

Line 3684: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');

3680:
3681: -- Debug Message
3682: IF (PV_DEBUG_HIGH_ON) THEN
3683:
3684: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
3685: END IF;
3686:
3687: -- Standard call to get message count and if count is 1, get message info.
3688: FND_MSG_PUB.Count_And_Get

Line 3701: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM ERROR BLOCK');

3697: ROLLBACK TO VALIDATE_Partner_Program_;
3698: x_return_status := FND_API.G_RET_STS_ERROR;
3699: IF (PV_DEBUG_HIGH_ON) THEN
3700:
3701: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM ERROR BLOCK');
3702: END IF;
3703: -- Standard call to get message count and if count=1, get the message
3704: FND_MSG_PUB.Count_And_Get (
3705: p_encoded => FND_API.G_FALSE,

Line 3715: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM UNEXPECTED ERROR BLOCK');

3711: ROLLBACK TO VALIDATE_Partner_Program_;
3712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3713: IF (PV_DEBUG_HIGH_ON) THEN
3714:
3715: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM UNEXPECTED ERROR BLOCK');
3716: END IF;
3717: -- Standard call to get message count and if count=1, get the message
3718: FND_MSG_PUB.Count_And_Get (
3719: p_encoded => FND_API.G_FALSE,

Line 3733: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM WHEN OTHERS BLOCK');

3729: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3730: END IF;
3731: IF (PV_DEBUG_HIGH_ON) THEN
3732:
3733: PVX_UTILITY_PVT.debug_message('IN VALIDATE PROGRAM WHEN OTHERS BLOCK');
3734: END IF;
3735: -- Standard call to get message count and if count=1, get the message
3736: FND_MSG_PUB.Count_And_Get (
3737: p_encoded => FND_API.G_FALSE

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

4094: END IF;
4095:
4096: -- Debug Message
4097: IF (PV_DEBUG_HIGH_ON) THEN
4098: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4099: END IF;
4100:
4101: -- Initialize API return status to SUCCESS
4102: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4109: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_COPY_SOURCE',

4105: OPEN c_get_ptr_prgm_rec (p_source_object_id);
4106: FETCH c_get_ptr_prgm_rec INTO l_src_ptr_pgrm_rec;
4107:
4108: If (c_get_ptr_prgm_rec%NOTFOUND) THEN
4109: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_COPY_SOURCE',
4110: p_token_name => 'SOURCE',
4111: p_token_value => 'Program');
4112: RAISE FND_API.G_EXC_ERROR;
4113: END IF;

Line 4171: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QSNR');

4167:
4168: -- add this for the questionnaire flag
4169: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN
4170: IF (PV_DEBUG_HIGH_ON) THEN
4171: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QSNR');
4172: END IF;
4173: l_new_ptr_pgrm_rec.QSNR_TTL_ALL_PAGE_DSP_FLAG := l_src_ptr_pgrm_rec.QSNR_TTL_ALL_PAGE_DSP_FLAG;
4174: l_new_ptr_pgrm_rec.QSNR_HDR_ALL_PAGE_DSP_FLAG := l_src_ptr_pgrm_rec.QSNR_HDR_ALL_PAGE_DSP_FLAG;
4175: l_new_ptr_pgrm_rec.QSNR_FTR_ALL_PAGE_DSP_FLAG := l_src_ptr_pgrm_rec.QSNR_FTR_ALL_PAGE_DSP_FLAG;

Line 4181: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');

4177:
4178: -- add this for the allow_enrl_wo_cl_flag flag
4179: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN
4180: IF (PV_DEBUG_HIGH_ON) THEN
4181: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');
4182: END IF;
4183: l_new_ptr_pgrm_rec.allow_enrl_wout_chklst_flag := l_src_ptr_pgrm_rec.allow_enrl_wout_chklst_flag;
4184: END IF;
4185:

Line 4209: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');

4205:
4206: -- For requirements
4207: IF AMS_CpyUtility_PVT.is_copy_attribute ('QUAL', p_attributes_table) = FND_API.G_TRUE THEN
4208: IF (PV_DEBUG_HIGH_ON) THEN
4209: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4210: END IF;
4211:
4212: PV_Partner_Program_PVT.Copy_Qualifications (
4213: p_api_version_number => 1.0,

Line 4231: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'BNFT');

4227:
4228: -- For benefits
4229: IF AMS_CpyUtility_PVT.is_copy_attribute ('BNFT', p_attributes_table) = FND_API.G_TRUE THEN
4230: IF (PV_DEBUG_HIGH_ON) THEN
4231: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'BNFT');
4232: END IF;
4233:
4234: PV_Partner_Program_PVT.Copy_Benefits (
4235: p_api_version_number => 1.0,

Line 4255: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'PMNT');

4251:
4252: -- For pricing
4253: IF AMS_CpyUtility_PVT.is_copy_attribute ('PMNT', p_attributes_table) = FND_API.G_TRUE THEN
4254: IF (PV_DEBUG_HIGH_ON) THEN
4255: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'PMNT');
4256: END IF;
4257: PV_Partner_Program_PVT.Copy_payments (
4258: p_api_version_number => 1.0,
4259: p_init_msg_list => FND_API.G_FALSE,

Line 4274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'GEOG');

4270:
4271: -- For geography
4272: IF AMS_CpyUtility_PVT.is_copy_attribute ('GEOG', p_attributes_table) = FND_API.G_TRUE THEN
4273: IF (PV_DEBUG_HIGH_ON) THEN
4274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'GEOG');
4275: END IF;
4276: AMS_COPYELEMENTS_PVT.copy_act_geo_areas (
4277: p_src_act_type => 'PRGM',
4278: p_new_act_type => 'PRGM',

Line 4295: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'LGLT');

4291:
4292: -- For legal terms
4293: IF AMS_CpyUtility_PVT.is_copy_attribute ('LGLT', p_attributes_table) = FND_API.G_TRUE THEN
4294: IF (PV_DEBUG_HIGH_ON) THEN
4295: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'LGLT');
4296: END IF;
4297: PV_Partner_Program_PVT.Copy_Legal_Terms (
4298: p_api_version_number => 1.0,
4299: p_init_msg_list => FND_API.G_FALSE,

Line 4317: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');

4313:
4314: -- For enrollment questionnaire
4315: IF AMS_CpyUtility_PVT.is_copy_attribute ('QSNR', p_attributes_table) = FND_API.G_TRUE THEN
4316: IF (PV_DEBUG_HIGH_ON) THEN
4317: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4318: END IF;
4319: PV_Partner_Program_PVT.Copy_Questionnaire (
4320: p_api_version_number => 1.0,
4321: p_init_msg_list => FND_API.G_FALSE,

Line 4340: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');

4336:
4337: -- For approval checklist
4338: IF AMS_CpyUtility_PVT.is_copy_attribute ('CHKLST', p_attributes_table) = FND_API.G_TRUE THEN
4339: IF (PV_DEBUG_HIGH_ON) THEN
4340: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'CHKLST');
4341: END IF;
4342: PV_Partner_Program_PVT.Copy_Checklist (
4343: p_api_version_number => 1.0,
4344: p_init_msg_list => FND_API.G_FALSE,

Line 4363: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');

4359:
4360: -- For notification rules
4361: IF AMS_CpyUtility_PVT.is_copy_attribute ('NOTIF', p_attributes_table) = FND_API.G_TRUE THEN
4362: IF (PV_DEBUG_HIGH_ON) THEN
4363: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'QUAL');
4364: END IF;
4365:
4366: PV_Partner_Program_PVT.Copy_Notif_Rules (
4367: p_api_version_number => 1.0,

Line 4387: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'TEAM');

4383:
4384: -- For team
4385: IF AMS_CpyUtility_PVT.is_copy_attribute ('TEAM', p_attributes_table) = FND_API.G_TRUE THEN
4386: IF (PV_DEBUG_HIGH_ON) THEN
4387: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'TEAM');
4388: END IF;
4389: AMS_COPYELEMENTS_PVT.copy_act_access (
4390: p_src_act_type => 'PRGM',
4391: p_new_act_type => 'PRGM',

Line 4410: WHEN PVX_Utility_PVT.resource_locked THEN

4406:
4407:
4408: EXCEPTION
4409:
4410: WHEN PVX_Utility_PVT.resource_locked THEN
4411: x_return_status := FND_API.g_ret_sts_error;
4412: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4413:
4414: WHEN FND_API.G_EXC_ERROR THEN

Line 4412: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4408: EXCEPTION
4409:
4410: WHEN PVX_Utility_PVT.resource_locked THEN
4411: x_return_status := FND_API.g_ret_sts_error;
4412: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4413:
4414: WHEN FND_API.G_EXC_ERROR THEN
4415: ROLLBACK TO Copy_Program;
4416: x_return_status := FND_API.G_RET_STS_ERROR;

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

4535: END IF;
4536:
4537: -- Debug Message
4538: IF (PV_DEBUG_HIGH_ON) THEN
4539: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4540: END IF;
4541:
4542: -- Initialize API return status to SUCCESS
4543: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4556: PVX_UTILITY_PVT.debug_message('l_src_process_rule_id = ' || l_src_process_rule_id);

4552: FOR x IN c_get_process_rule_id (p_src_object_id)
4553: LOOP
4554: l_src_process_rule_id := x.id;
4555: IF (PV_DEBUG_HIGH_ON) THEN
4556: PVX_UTILITY_PVT.debug_message('l_src_process_rule_id = ' || l_src_process_rule_id);
4557: PVX_UTILITY_PVT.debug_message('x.rule = ' || x.rule);
4558: END IF;
4559:
4560: FOR l_src_process_rule_rec IN c_get_process_rule_rec (l_src_process_rule_id)

Line 4557: PVX_UTILITY_PVT.debug_message('x.rule = ' || x.rule);

4553: LOOP
4554: l_src_process_rule_id := x.id;
4555: IF (PV_DEBUG_HIGH_ON) THEN
4556: PVX_UTILITY_PVT.debug_message('l_src_process_rule_id = ' || l_src_process_rule_id);
4557: PVX_UTILITY_PVT.debug_message('x.rule = ' || x.rule);
4558: END IF;
4559:
4560: FOR l_src_process_rule_rec IN c_get_process_rule_rec (l_src_process_rule_id)
4561: LOOP

Line 4606: PVX_UTILITY_PVT.debug_message('l_fake_process_rule_rec.process_rule_id = ' || l_fake_process_rule_rec.process_rule_id);

4602: FOR x IN c_get_process_rule_id (p_tar_object_id)
4603: LOOP
4604: l_fake_process_rule_rec.process_rule_id := x.id;
4605: IF (PV_DEBUG_HIGH_ON) THEN
4606: PVX_UTILITY_PVT.debug_message('l_fake_process_rule_rec.process_rule_id = ' || l_fake_process_rule_rec.process_rule_id);
4607: END IF;
4608: --l_fake_process_rule_rec.object_version_number := 1;
4609: PV_PROCESS_RULE_PVT.Delete_process_rule(
4610: p_api_version_number => 2.0

Line 4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);

4656: l_tar_pec_rules_rec.effective_to_date := l_src_pec_rules_rec.effective_to_date;
4657: l_tar_pec_rules_rec.active_flag := l_src_pec_rules_rec.active_flag;
4658:
4659: IF (PV_DEBUG_HIGH_ON) THEN
4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);
4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);

Line 4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);

4657: l_tar_pec_rules_rec.active_flag := l_src_pec_rules_rec.active_flag;
4658:
4659: IF (PV_DEBUG_HIGH_ON) THEN
4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);
4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);

Line 4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);

4658:
4659: IF (PV_DEBUG_HIGH_ON) THEN
4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);
4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4666: END IF;

Line 4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);

4659: IF (PV_DEBUG_HIGH_ON) THEN
4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);
4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4666: END IF;
4667:

Line 4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);

4660: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_to_program_id = ' || l_tar_pec_rules_rec.change_to_program_id);
4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4666: END IF;
4667:
4668: PV_Pec_Rules_PVT.Create_Pec_Rules (

Line 4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);

4661: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_from_program_id = ' || l_tar_pec_rules_rec.change_from_program_id);
4662: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.change_direction_code = ' || l_tar_pec_rules_rec.change_direction_code);
4663: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_from_date = ' || l_tar_pec_rules_rec.effective_from_date);
4664: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4665: PVX_UTILITY_PVT.debug_message('l_tar_pec_rules_rec.effective_to_date = ' || l_tar_pec_rules_rec.effective_to_date);
4666: END IF;
4667:
4668: PV_Pec_Rules_PVT.Create_Pec_Rules (
4669: p_api_version_number => p_api_version_number

Line 4697: WHEN PVX_Utility_PVT.resource_locked THEN

4693: );
4694:
4695: EXCEPTION
4696:
4697: WHEN PVX_Utility_PVT.resource_locked THEN
4698: x_return_status := FND_API.g_ret_sts_error;
4699: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4700:
4701: WHEN FND_API.G_EXC_ERROR THEN

Line 4699: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4695: EXCEPTION
4696:
4697: WHEN PVX_Utility_PVT.resource_locked THEN
4698: x_return_status := FND_API.g_ret_sts_error;
4699: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4700:
4701: WHEN FND_API.G_EXC_ERROR THEN
4702: ROLLBACK TO Copy_Qualifications;
4703: x_return_status := FND_API.G_RET_STS_ERROR;

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

4788: END IF;
4789:
4790: -- Debug Message
4791: IF (PV_DEBUG_HIGH_ON) THEN
4792: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4793: END IF;
4794:
4795: -- Initialize API return status to SUCCESS
4796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);

4809: --l_tar_prgm_benefits_rec.created_by := l_src_prgm_benefits_rec.created_by;
4810: --l_tar_prgm_benefits_rec.creation_date := l_src_prgm_benefits_rec.creation_date;
4811:
4812: IF (PV_DEBUG_HIGH_ON) THEN
4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);
4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);
4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);
4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);
4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);

Line 4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);

4810: --l_tar_prgm_benefits_rec.creation_date := l_src_prgm_benefits_rec.creation_date;
4811:
4812: IF (PV_DEBUG_HIGH_ON) THEN
4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);
4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);
4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);
4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);
4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);
4818: END IF;

Line 4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);

4811:
4812: IF (PV_DEBUG_HIGH_ON) THEN
4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);
4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);
4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);
4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);
4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);
4818: END IF;
4819:

Line 4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);

4812: IF (PV_DEBUG_HIGH_ON) THEN
4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);
4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);
4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);
4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);
4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);
4818: END IF;
4819:
4820: PV_PRGM_BENEFITS_PVT.Create_Prgm_Benefits (

Line 4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);

4813: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.program_id = ' || l_tar_prgm_benefits_rec.program_id);
4814: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_code = ' || l_tar_prgm_benefits_rec.benefit_code);
4815: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_id = ' || l_tar_prgm_benefits_rec.benefit_id);
4816: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.benefit_type_code = ' || l_tar_prgm_benefits_rec.benefit_type_code);
4817: PVX_UTILITY_PVT.debug_message('l_tar_prgm_benefits_rec.delete_flag = ' || l_tar_prgm_benefits_rec.delete_flag);
4818: END IF;
4819:
4820: PV_PRGM_BENEFITS_PVT.Create_Prgm_Benefits (
4821: p_api_version_number => p_api_version_number

Line 4849: WHEN PVX_Utility_PVT.resource_locked THEN

4845: );
4846:
4847: EXCEPTION
4848:
4849: WHEN PVX_Utility_PVT.resource_locked THEN
4850: x_return_status := FND_API.g_ret_sts_error;
4851: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4852:
4853: WHEN FND_API.G_EXC_ERROR THEN

Line 4851: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4847: EXCEPTION
4848:
4849: WHEN PVX_Utility_PVT.resource_locked THEN
4850: x_return_status := FND_API.g_ret_sts_error;
4851: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4852:
4853: WHEN FND_API.G_EXC_ERROR THEN
4854: ROLLBACK TO Copy_Benefits;
4855: x_return_status := FND_API.G_RET_STS_ERROR;

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

4939: END IF;
4940:
4941: -- Debug Message
4942: IF (PV_DEBUG_HIGH_ON) THEN
4943: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
4944: END IF;
4945:
4946: -- Initialize API return status to SUCCESS
4947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4953: PVX_UTILITY_PVT.debug_message('l_org_inv_item_id = ' || l_org_inv_item_id);

4949: FOR x IN c_get_inventory_item_id (p_src_object_id)
4950: LOOP
4951: l_org_inv_item_id := x.inventory_item_id;
4952: IF (PV_DEBUG_HIGH_ON) THEN
4953: PVX_UTILITY_PVT.debug_message('l_org_inv_item_id = ' || l_org_inv_item_id);
4954: END IF;
4955: END LOOP;
4956:
4957: l_index := 1;

Line 4962: PVX_UTILITY_PVT.debug_message('l_new_inv_item_id(' || l_index || ') = ' || l_new_inv_item_id(l_index));

4958: FOR x IN c_get_inventory_item_id (p_tar_object_id)
4959: LOOP
4960: l_new_inv_item_id(l_index) := x.inventory_item_id;
4961: IF (PV_DEBUG_HIGH_ON) THEN
4962: PVX_UTILITY_PVT.debug_message('l_new_inv_item_id(' || l_index || ') = ' || l_new_inv_item_id(l_index));
4963: END IF;
4964: l_index := l_index + 1;
4965: END LOOP;
4966:

Line 4996: WHEN PVX_Utility_PVT.resource_locked THEN

4992: );
4993:
4994: EXCEPTION
4995:
4996: WHEN PVX_Utility_PVT.resource_locked THEN
4997: x_return_status := FND_API.g_ret_sts_error;
4998: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4999:
5000: WHEN FND_API.G_EXC_ERROR THEN

Line 4998: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

4994: EXCEPTION
4995:
4996: WHEN PVX_Utility_PVT.resource_locked THEN
4997: x_return_status := FND_API.g_ret_sts_error;
4998: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
4999:
5000: WHEN FND_API.G_EXC_ERROR THEN
5001: ROLLBACK TO Copy_Payments;
5002: x_return_status := FND_API.G_RET_STS_ERROR;

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

5086: END IF;
5087:
5088: -- Debug Message
5089: IF (PV_DEBUG_HIGH_ON) THEN
5090: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5091: END IF;
5092:
5093: -- Initialize API return status to SUCCESS
5094: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5104: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.program_id = ' || l_tar_prgm_contracts_rec.program_id);

5100: l_tar_prgm_contracts_rec.contract_id := l_src_prgm_contracts_rec.contract_id;
5101: l_tar_prgm_contracts_rec.member_type_code := l_src_prgm_contracts_rec.member_type_code;
5102:
5103: IF (PV_DEBUG_HIGH_ON) THEN
5104: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.program_id = ' || l_tar_prgm_contracts_rec.program_id);
5105: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.geo_hierarchy_id = ' || l_tar_prgm_contracts_rec.geo_hierarchy_id);
5106: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.contract_id = ' || l_tar_prgm_contracts_rec.contract_id);
5107: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.member_type_code = ' || l_tar_prgm_contracts_rec.member_type_code);
5108: END IF;

Line 5105: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.geo_hierarchy_id = ' || l_tar_prgm_contracts_rec.geo_hierarchy_id);

5101: l_tar_prgm_contracts_rec.member_type_code := l_src_prgm_contracts_rec.member_type_code;
5102:
5103: IF (PV_DEBUG_HIGH_ON) THEN
5104: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.program_id = ' || l_tar_prgm_contracts_rec.program_id);
5105: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.geo_hierarchy_id = ' || l_tar_prgm_contracts_rec.geo_hierarchy_id);
5106: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.contract_id = ' || l_tar_prgm_contracts_rec.contract_id);
5107: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.member_type_code = ' || l_tar_prgm_contracts_rec.member_type_code);
5108: END IF;
5109:

Line 5106: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.contract_id = ' || l_tar_prgm_contracts_rec.contract_id);

5102:
5103: IF (PV_DEBUG_HIGH_ON) THEN
5104: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.program_id = ' || l_tar_prgm_contracts_rec.program_id);
5105: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.geo_hierarchy_id = ' || l_tar_prgm_contracts_rec.geo_hierarchy_id);
5106: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.contract_id = ' || l_tar_prgm_contracts_rec.contract_id);
5107: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.member_type_code = ' || l_tar_prgm_contracts_rec.member_type_code);
5108: END IF;
5109:
5110: PV_PRGM_CONTRACTS_PVT.Create_Prgm_Contracts (

Line 5107: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.member_type_code = ' || l_tar_prgm_contracts_rec.member_type_code);

5103: IF (PV_DEBUG_HIGH_ON) THEN
5104: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.program_id = ' || l_tar_prgm_contracts_rec.program_id);
5105: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.geo_hierarchy_id = ' || l_tar_prgm_contracts_rec.geo_hierarchy_id);
5106: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.contract_id = ' || l_tar_prgm_contracts_rec.contract_id);
5107: PVX_UTILITY_PVT.debug_message('l_tar_prgm_contracts_rec.member_type_code = ' || l_tar_prgm_contracts_rec.member_type_code);
5108: END IF;
5109:
5110: PV_PRGM_CONTRACTS_PVT.Create_Prgm_Contracts (
5111: p_api_version_number => p_api_version_number

Line 5139: WHEN PVX_Utility_PVT.resource_locked THEN

5135: );
5136:
5137: EXCEPTION
5138:
5139: WHEN PVX_Utility_PVT.resource_locked THEN
5140: x_return_status := FND_API.g_ret_sts_error;
5141: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5142:
5143: WHEN FND_API.G_EXC_ERROR THEN

Line 5141: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5137: EXCEPTION
5138:
5139: WHEN PVX_Utility_PVT.resource_locked THEN
5140: x_return_status := FND_API.g_ret_sts_error;
5141: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5142:
5143: WHEN FND_API.G_EXC_ERROR THEN
5144: ROLLBACK TO Copy_Legal_Terms;
5145: x_return_status := FND_API.G_RET_STS_ERROR;

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

5222: END IF;
5223:
5224: -- Debug Message
5225: IF (PV_DEBUG_HIGH_ON) THEN
5226: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5227: END IF;
5228:
5229: -- Initialize API return status to SUCCESS
5230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5258: WHEN PVX_Utility_PVT.resource_locked THEN

5254: );
5255:
5256: EXCEPTION
5257:
5258: WHEN PVX_Utility_PVT.resource_locked THEN
5259: x_return_status := FND_API.g_ret_sts_error;
5260: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5261:
5262: WHEN FND_API.G_EXC_ERROR THEN

Line 5260: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5256: EXCEPTION
5257:
5258: WHEN PVX_Utility_PVT.resource_locked THEN
5259: x_return_status := FND_API.g_ret_sts_error;
5260: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5261:
5262: WHEN FND_API.G_EXC_ERROR THEN
5263: ROLLBACK TO Copy_Questionnaire;
5264: x_return_status := FND_API.G_RET_STS_ERROR;

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

5344: END IF;
5345:
5346: -- Debug Message
5347: IF (PV_DEBUG_HIGH_ON) THEN
5348: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5349: END IF;
5350: --dbms_output.put_line('Copy_Checklist');
5351:
5352: -- Initialize API return status to SUCCESS

Line 5381: WHEN PVX_Utility_PVT.resource_locked THEN

5377: );
5378:
5379: EXCEPTION
5380:
5381: WHEN PVX_Utility_PVT.resource_locked THEN
5382: x_return_status := FND_API.g_ret_sts_error;
5383: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5384:
5385: WHEN FND_API.G_EXC_ERROR THEN

Line 5383: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5379: EXCEPTION
5380:
5381: WHEN PVX_Utility_PVT.resource_locked THEN
5382: x_return_status := FND_API.g_ret_sts_error;
5383: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5384:
5385: WHEN FND_API.G_EXC_ERROR THEN
5386: ROLLBACK TO Copy_Checklist;
5387: x_return_status := FND_API.G_RET_STS_ERROR;

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

5465: END IF;
5466:
5467: -- Debug Message
5468: IF (PV_DEBUG_HIGH_ON) THEN
5469: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
5470: END IF;
5471:
5472: -- Initialize API return status to SUCCESS
5473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5507: WHEN PVX_Utility_PVT.resource_locked THEN

5503: );
5504:
5505: EXCEPTION
5506:
5507: WHEN PVX_Utility_PVT.resource_locked THEN
5508: x_return_status := FND_API.g_ret_sts_error;
5509: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5510:
5511: WHEN FND_API.G_EXC_ERROR THEN

Line 5509: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

5505: EXCEPTION
5506:
5507: WHEN PVX_Utility_PVT.resource_locked THEN
5508: x_return_status := FND_API.g_ret_sts_error;
5509: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
5510:
5511: WHEN FND_API.G_EXC_ERROR THEN
5512: ROLLBACK TO Copy_Notif_Rules;
5513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5591: PVX_UTILITY_PVT.debug_message(' in Update_Partner_Program');

5587:
5588: BEGIN
5589:
5590: IF (PV_DEBUG_HIGH_ON) THEN
5591: PVX_UTILITY_PVT.debug_message(' in Update_Partner_Program');
5592: END IF;
5593:
5594:
5595:

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

5596: -- Standard Start of API savepoint
5597: SAVEPOINT UPDATE_Partner_Program_PVT;
5598: -- Debug Message
5599: IF (PV_DEBUG_HIGH_ON) THEN
5600: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
5601: END IF;
5602:
5603: -- Standard call to check for call compatibility.
5604: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 5680: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );

5676: END IF;
5677:
5678: -- Debug message
5679: IF (PV_DEBUG_HIGH_ON) THEN
5680: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - PV_PROCESS_RULES_PUB.Create_Process_Rules return_status = ' || x_return_status );
5681: END IF;
5682: -- End of call to PV_PROCESS_RULES_PUB.Create_Process_Rules
5683:
5684: l_ptr_prgm_rec.program_id:=p_program_id;

Line 5708: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

5704: END IF;
5705:
5706: -- Debug Message
5707: IF (PV_DEBUG_HIGH_ON) THEN
5708: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
5709: END IF;
5710:
5711: -- Standard check for p_commit
5712: IF FND_API.to_Boolean( p_commit ) THEN

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

5746: WHERE program_id = p_program_id;
5747:
5748: BEGIN
5749: IF (PV_DEBUG_HIGH_ON) THEN
5750: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
5751: END IF;
5752:
5753: -- Standard call to check for call compatibility.
5754: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 5775: PVX_UTILITY_PVT.debug_message('l_ptr_prgm_rec.program_name: ' || l_ptr_prgm_rec.program_name);

5771: FOR x IN c_get_program_info LOOP
5772: l_ptr_prgm_rec.program_id := p_program_id;
5773: l_ptr_prgm_rec.program_name := x.program_name;
5774: IF (PV_DEBUG_HIGH_ON) THEN
5775: PVX_UTILITY_PVT.debug_message('l_ptr_prgm_rec.program_name: ' || l_ptr_prgm_rec.program_name);
5776: END IF;
5777:
5778: IF (x.inventory_item_id is null AND x.inventory_item_org_id is null) THEN
5779: create_inventory_item(

Line 5792: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_id: ' || l_Item_rec.inventory_item_id);

5788: RAISE FND_API.g_exc_unexpected_error;
5789: END IF;
5790:
5791: IF (PV_DEBUG_HIGH_ON) THEN
5792: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_id: ' || l_Item_rec.inventory_item_id);
5793: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_org_id: ' || l_Item_rec.organization_id);
5794: END IF;
5795:
5796: x_inventory_item_id := l_Item_rec.inventory_item_id;

Line 5793: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_org_id: ' || l_Item_rec.organization_id);

5789: END IF;
5790:
5791: IF (PV_DEBUG_HIGH_ON) THEN
5792: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_id: ' || l_Item_rec.inventory_item_id);
5793: PVX_UTILITY_PVT.debug_message('l_Item_rec.inventory_item_org_id: ' || l_Item_rec.organization_id);
5794: END IF;
5795:
5796: x_inventory_item_id := l_Item_rec.inventory_item_id;
5797: x_inventory_item_org_id := l_Item_rec.organization_id;