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.PVX_LEAD_PSS_LINES_PVT dependencies on PVX_UTILITY_PVT

Line 74: PVX_Utility_PVT.debug_message(l_full_name||': start');

70: --------------------- initialize -----------------------
71: SAVEPOINT Create_lead_pss_line;
72:
73: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
74: PVX_Utility_PVT.debug_message(l_full_name||': start');
75: END IF;
76:
77:
78: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 95: PVX_Utility_PVT.debug_message(l_full_name ||': validate');

91: x_return_status := FND_API.g_ret_sts_success;
92:
93: ----------------------- validate -----------------------
94: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
95: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
96: END IF;
97:
98:
99:

Line 123: PVX_Utility_PVT.debug_message(l_full_name ||': insert');

119:
120:
121: -------------------------- insert --------------------------
122: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
123: PVX_Utility_PVT.debug_message(l_full_name ||': insert');
124: END IF;
125:
126:
127:

Line 242: PVX_Utility_PVT.debug_message(l_full_name ||': end');

238: p_data => x_msg_data
239: );
240:
241: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
242: PVX_Utility_PVT.debug_message(l_full_name ||': end');
243: END IF;
244:
245:
246: EXCEPTION

Line 315: PVX_Utility_PVT.debug_message(l_full_name||': start');

311: --------------------- initialize -----------------------
312: SAVEPOINT Delete_lead_pss_line;
313:
314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
315: PVX_Utility_PVT.debug_message(l_full_name||': start');
316: END IF;
317:
318:
319:

Line 337: PVX_Utility_PVT.debug_message(l_full_name ||': delete');

333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: ------------------------ delete ------------------------
336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
337: PVX_Utility_PVT.debug_message(l_full_name ||': delete');
338: END IF;
339:
340:
341: DELETE FROM PV_LEAD_PSS_LINES

Line 366: PVX_Utility_PVT.debug_message(l_full_name ||': end');

362: p_data => x_msg_data
363: );
364:
365: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
366: PVX_Utility_PVT.debug_message(l_full_name ||': end');
367: END IF;
368:
369:
370:

Line 444: PVX_Utility_PVT.debug_message(l_full_name||': start');

440: BEGIN
441:
442: -------------------- initialize ------------------------
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
444: PVX_Utility_PVT.debug_message(l_full_name||': start');
445: END IF;
446:
447:
448: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 465: PVX_Utility_PVT.debug_message(l_full_name||': lock');

461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: ------------------------ lock -------------------------
464: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
465: PVX_Utility_PVT.debug_message(l_full_name||': lock');
466: END IF;
467:
468:
469: OPEN c_lead_pss_line;

Line 491: PVX_Utility_PVT.debug_message(l_full_name ||': end');

487: );
488:
489:
490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
491: PVX_Utility_PVT.debug_message(l_full_name ||': end');
492: END IF;
493:
494:
495:

Line 498: WHEN PVX_Utility_PVT.resource_locked THEN

494:
495:
496: EXCEPTION
497:
498: WHEN PVX_Utility_PVT.resource_locked THEN
499: x_return_status := FND_API.g_ret_sts_error;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
501: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
502: FND_MSG_PUB.add;

Line 576: PVX_Utility_PVT.debug_message(l_full_name||': start');

572: -------------------- initialize -------------------------
573: SAVEPOINT Update_lead_pss_line;
574:
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
576: PVX_Utility_PVT.debug_message(l_full_name||': start');
577: END IF;
578:
579:
580: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 597: PVX_Utility_PVT.debug_message(l_full_name ||': validate');

593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: ----------------------- validate ----------------------
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
597: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
598: END IF;
599:
600:
601: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 641: PVX_Utility_PVT.debug_message(l_full_name ||': update');

637: END IF;
638:
639: -------------------------- update --------------------
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
641: PVX_Utility_PVT.debug_message(l_full_name ||': update');
642: END IF;
643:
644:
645:

Line 711: PVX_Utility_PVT.debug_message(l_full_name ||': end');

707: p_data => x_msg_data
708: );
709:
710: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
711: PVX_Utility_PVT.debug_message(l_full_name ||': end');
712: END IF;
713:
714:
715:

Line 784: PVX_Utility_PVT.debug_message(l_full_name||': start');

780:
781:
782: ----------------------- initialize --------------------
783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
784: PVX_Utility_PVT.debug_message(l_full_name||': start');
785: END IF;
786:
787:
788: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 805: PVX_Utility_PVT.debug_message(l_full_name||': check items');

801: x_return_status := FND_API.g_ret_sts_success;
802:
803: ---------------------- validate ------------------------
804: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
805: PVX_Utility_PVT.debug_message(l_full_name||': check items');
806: END IF;
807:
808:
809:

Line 829: PVX_Utility_PVT.debug_message(l_full_name||': check record');

825:
826:
827:
828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
829: PVX_Utility_PVT.debug_message(l_full_name||': check record');
830: END IF;
831:
832:
833:

Line 863: PVX_Utility_PVT.debug_message(l_full_name ||': end');

859: p_data => x_msg_data
860: );
861:
862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
863: PVX_Utility_PVT.debug_message(l_full_name ||': end');
864: END IF;
865:
866:
867:

Line 972: IF PVX_Utility_PVT.check_uniqueness(

968: -- check if this is unique.
969: IF p_validation_mode = JTF_PLSQL_API.g_create
970: AND p_lead_pss_lines_rec.lead_pss_line_id IS NOT NULL
971: THEN
972: IF PVX_Utility_PVT.check_uniqueness(
973: 'PV_lead_pss_lines',
974: 'lead_pss_line_id = ' || p_lead_pss_lines_rec.lead_pss_line_id
975: ) = FND_API.g_false
976: THEN

Line 1009: IF PVX_Utility_PVT.check_fk_exists(

1005:
1006:
1007: ----------------------- lead_id ------------------------
1008: IF (p_lead_pss_lines_rec.lead_id <> FND_API.g_miss_num and p_lead_pss_lines_rec.object_name = 'OPPORTUNITY') THEN
1009: IF PVX_Utility_PVT.check_fk_exists(
1010: 'as_leads_all', -- Parent schema object having the primary key
1011: 'lead_id', -- Column name in the parent object that maps to the fk value
1012: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1013: PVX_utility_PVT.g_number -- datatype of fk

Line 1013: PVX_utility_PVT.g_number -- datatype of fk

1009: IF PVX_Utility_PVT.check_fk_exists(
1010: 'as_leads_all', -- Parent schema object having the primary key
1011: 'lead_id', -- Column name in the parent object that maps to the fk value
1012: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1013: PVX_utility_PVT.g_number -- datatype of fk
1014: ) = FND_API.g_false
1015: THEN
1016: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1017: THEN

Line 1028: IF PVX_Utility_PVT.check_fk_exists(

1024: END IF;
1025:
1026: else IF (p_lead_pss_lines_rec.lead_id <> FND_API.g_miss_num and p_lead_pss_lines_rec.object_name = 'LEAD') then
1027:
1028: IF PVX_Utility_PVT.check_fk_exists(
1029: 'as_sales_leads', -- Parent schema object having the primary key
1030: 'sales_lead_id', -- Column name in the parent object that maps to the fk value
1031: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1032: PVX_utility_PVT.g_number -- datatype of fk

Line 1032: PVX_utility_PVT.g_number -- datatype of fk

1028: IF PVX_Utility_PVT.check_fk_exists(
1029: 'as_sales_leads', -- Parent schema object having the primary key
1030: 'sales_lead_id', -- Column name in the parent object that maps to the fk value
1031: p_lead_pss_lines_rec.object_id, -- Value of fk to be validated against the parent object's pk column
1032: PVX_utility_PVT.g_number -- datatype of fk
1033: ) = FND_API.g_false
1034: THEN
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1036: THEN

Line 1049: IF PVX_Utility_PVT.check_fk_exists(

1045: END IF;
1046:
1047: ----------------------- attr_code_id ------------------------
1048: IF p_lead_pss_lines_rec.attr_code_id <> FND_API.g_miss_num THEN
1049: IF PVX_Utility_PVT.check_fk_exists(
1050: 'pv_attribute_codes_vl', -- Parent schema object having the primary key
1051: 'attr_code_id', -- Column name in the parent object that maps to the fk value
1052: p_lead_pss_lines_rec.attr_code_id, -- Value of fk to be validated against the parent object's pk column
1053: PVX_utility_PVT.g_number -- datatype of fk

Line 1053: PVX_utility_PVT.g_number -- datatype of fk

1049: IF PVX_Utility_PVT.check_fk_exists(
1050: 'pv_attribute_codes_vl', -- Parent schema object having the primary key
1051: 'attr_code_id', -- Column name in the parent object that maps to the fk value
1052: p_lead_pss_lines_rec.attr_code_id, -- Value of fk to be validated against the parent object's pk column
1053: PVX_utility_PVT.g_number -- datatype of fk
1054: ) = FND_API.g_false
1055: THEN
1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1057: THEN

Line 1090: IF PVX_Utility_PVT.check_lookup_exists(

1086:
1087: ----------------------- object_name lookup ------------------------
1088: IF p_lead_pss_lines_rec.object_name <> FND_API.g_miss_char THEN
1089:
1090: IF PVX_Utility_PVT.check_lookup_exists(
1091: 'pv_lookups', -- Look up Table Name
1092: 'PV_OBJECT_NAME', -- Lookup Type
1093: p_lead_pss_lines_rec.object_name -- Lookup Code
1094: ) = FND_API.g_false