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.AS_SALES_LEAD_OWNER dependencies on AS_UTILITY_PVT

Line 67: IF AS_Utility_PVT.check_fk_exists(

63: END IF;
64: CLOSE c_cm_exsist;
65:
66: /*
67: IF AS_Utility_PVT.check_fk_exists(
68: 'jtf_rs_resource_extns', -- Parent schema object having the primary key
69: 'resource_id', -- Column name in the parent object that maps to the fk value
70: p_Lead_Owner_rec.CM_resource_id, -- Value of fk to be validated against the parent object's pk column
71: AS_Utility_PVT.g_number -- datatype of fk

Line 71: AS_Utility_PVT.g_number -- datatype of fk

67: IF AS_Utility_PVT.check_fk_exists(
68: 'jtf_rs_resource_extns', -- Parent schema object having the primary key
69: 'resource_id', -- Column name in the parent object that maps to the fk value
70: p_Lead_Owner_rec.CM_resource_id, -- Value of fk to be validated against the parent object's pk column
71: AS_Utility_PVT.g_number -- datatype of fk
72: ) = FND_API.g_false
73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN

Line 393: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

389:
390: BEGIN
391:
392: ----------------------- initialize --------------------
393: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
394:
395: IF FND_API.to_boolean(p_init_msg_list) THEN
396: FND_MSG_PUB.initialize;
397: END IF;

Line 411: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check items');

407:
408: x_return_status := FND_API.g_ret_sts_success;
409:
410: ---------------------- validate ------------------------
411: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check items');
412: --DBMS_output.put_line(l_full_name||': start item validate');
413:
414: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
415: Check_Lead_Owner_items(

Line 428: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check record');

424: RAISE FND_API.g_exc_error;
425: END IF;
426: END IF;
427:
428: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check record');
429: --DBMS_output.put_line(l_full_name||': start record validate');
430:
431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
432: Check_Lead_Owner_rec(

Line 452: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451:
452: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
453:
454: EXCEPTION
455:
456: WHEN FND_API.g_exc_error THEN

Line 556: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

552:
553: --------------------- initialize -----------------------
554: SAVEPOINT Create_Lead_Owner;
555:
556: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
557:
558:
559: IF FND_API.to_boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;

Line 575: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

571:
572: x_return_status := FND_API.g_ret_sts_success;
573:
574: ----------------------- validate -----------------------
575: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
576:
577: --DBMS_output.put_line(l_full_name||': validate');
578: Validate_Lead_Owner(
579: p_api_version => l_api_version,

Line 599: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': insert');

595:
596: --DBMS_output.put_line(l_full_name||': back validate');
597:
598: -------------------------- insert --------------------------
599: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': insert');
600:
601: IF l_Lead_Owner_rec.Lead_Owner_id IS NULL THEN
602: LOOP
603: -- Get the identifier

Line 688: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687:
688: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
689:
690: EXCEPTION
691:
692: WHEN FND_API.g_exc_error THEN

Line 758: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

754:
755: --------------------- initialize -----------------------
756: SAVEPOINT Delete_Lead_Owner;
757:
758: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
759:
760: IF FND_API.to_boolean(p_init_msg_list) THEN
761: FND_MSG_PUB.initialize;
762: END IF;

Line 776: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': delete');

772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: ------------------------ delete ------------------------
776: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': delete');
777:
778: DELETE FROM AS_SALES_LEAD_OWNERS
779: WHERE Lead_Owner_id = p_Lead_Owner_id
780: AND object_version_number = p_object_version;

Line 802: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:
802: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
803:
804: EXCEPTION
805:
806: WHEN FND_API.g_exc_error THEN

Line 877: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

873:
874: BEGIN
875:
876: -------------------- initialize ------------------------
877: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
878:
879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;

Line 895: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': lock');

891:
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:
894: ------------------------ lock -------------------------
895: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': lock');
896:
897: OPEN c_Lead_Owner;
898: FETCH c_Lead_Owner INTO l_Lead_Owner_id;
899: IF (c_Lead_Owner%NOTFOUND) THEN

Line 917: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );
916:
917: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
918:
919: EXCEPTION
920:
921: WHEN AS_Utility_PVT.resource_locked THEN

Line 921: WHEN AS_Utility_PVT.resource_locked THEN

917: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
918:
919: EXCEPTION
920:
921: WHEN AS_Utility_PVT.resource_locked THEN
922: x_return_status := FND_API.g_ret_sts_error;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
924: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
925: FND_MSG_PUB.add;

Line 998: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

994:
995: -------------------- initialize -------------------------
996: SAVEPOINT Update_Lead_Owner;
997:
998: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
999:
1000: IF FND_API.to_boolean(p_init_msg_list) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;

Line 1017: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014:
1015:
1016: ----------------------- validate ----------------------
1017: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1018:
1019: IF (p_Lead_Owner_rec.country is null) THEN
1020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1021: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

Line 1061: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': update');

1057: END IF;
1058:
1059:
1060: -------------------------- update --------------------
1061: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': update');
1062:
1063: UPDATE AS_SALES_LEAD_OWNERS SET
1064: category = l_Lead_Owner_rec.category
1065: ,country = l_Lead_Owner_rec.country

Line 1103: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102:
1103: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1104:
1105: EXCEPTION
1106:
1107: WHEN FND_API.g_exc_error THEN

Line 1201: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

1197:
1198: -------------------- initialize -------------------------
1199: SAVEPOINT Get_Salesreps;
1200:
1201: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
1202:
1203: IF FND_API.to_boolean(p_init_msg_list) THEN
1204: FND_MSG_PUB.initialize;
1205: END IF;

Line 1219: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

1215:
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:
1218: ----------------------- validate ----------------------
1219: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1220:
1221: IF (p_sales_lead_id is null) THEN
1222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1223: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

Line 1284: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

1280: p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );
1283:
1284: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1285:
1286: EXCEPTION
1287:
1288: WHEN FND_API.g_exc_error THEN

Line 1387: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');

1383:
1384: -------------------- initialize -------------------------
1385: SAVEPOINT Get_Salesreps;
1386:
1387: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
1388:
1389: IF FND_API.to_boolean(p_init_msg_list) THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;

Line 1405: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: ----------------------- validate ----------------------
1405: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1406:
1407: IF (p_sales_lead_id is null) THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

Line 1463: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting marketing owner from ptofile ');

1459:
1460: IF (l_salesreps_tbl.count > 0) THEN
1461: x_salesforce_id := l_salesreps_tbl(1).cm_resource_id;
1462: ELSE
1463: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Getting marketing owner from ptofile ');
1464: x_salesforce_id := fnd_profile.value('AS_DEFAULT_LEAD_MKTG_OWNER');
1465: END IF;
1466:
1467: -- Check for commit

Line 1478: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');

1474: p_count => x_msg_count,
1475: p_data => x_msg_data
1476: );
1477:
1478: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1479:
1480: EXCEPTION
1481:
1482: WHEN FND_API.g_exc_error THEN