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.OM_SETUP_VALID_PKG dependencies on OE_DEBUG_PUB

Line 23: OE_DEBUG_PUB.ADD('Inside OEXRSTVB : Validate_Main');

19: error_type VARCHAR2(15) := 'ERROR';
20: mesg_name VARCHAR2(255):= 'ONT_SETVAL_INVALID_INPUT';
21: ou NUMBER;
22: BEGIN
23: OE_DEBUG_PUB.ADD('Inside OEXRSTVB : Validate_Main');
24: RESP_LIST := GENERATE_LIST_RESP( P_LEVEL, P_VALUE );
25: IF ( P_LEVEL = 'RESP' AND (RESP_LIST(1) is null or RESP_LIST(1) = 0) ) THEN
26: ou := getOperatingUnit( P_VALUE );
27: errLogged := writeError( entity, P_LEVEL, P_VALUE, error_type, mesg_name ,

Line 33: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Resp_List');

29: null, null, null);
30: X_RETCODE := TRUE;
31: RETURN;
32: END IF;
33: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Resp_List');
34: OE_DEBUG_PUB.ADD('Resp_List count :'||RESP_lIST.COUNT);
35: APPS_LIST := GENERATE_LIST_APPS;
36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);

Line 34: OE_DEBUG_PUB.ADD('Resp_List count :'||RESP_lIST.COUNT);

30: X_RETCODE := TRUE;
31: RETURN;
32: END IF;
33: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Resp_List');
34: OE_DEBUG_PUB.ADD('Resp_List count :'||RESP_lIST.COUNT);
35: APPS_LIST := GENERATE_LIST_APPS;
36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);
38: USER_LIST := GENERATE_LIST_USER( P_LEVEL, P_VALUE );

Line 36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');

32: END IF;
33: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Resp_List');
34: OE_DEBUG_PUB.ADD('Resp_List count :'||RESP_lIST.COUNT);
35: APPS_LIST := GENERATE_LIST_APPS;
36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);
38: USER_LIST := GENERATE_LIST_USER( P_LEVEL, P_VALUE );
39: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Use_List');
40: OE_DEBUG_PUB.ADD('User_List count :'||USER_lIST.COUNT);

Line 37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);

33: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Resp_List');
34: OE_DEBUG_PUB.ADD('Resp_List count :'||RESP_lIST.COUNT);
35: APPS_LIST := GENERATE_LIST_APPS;
36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);
38: USER_LIST := GENERATE_LIST_USER( P_LEVEL, P_VALUE );
39: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Use_List');
40: OE_DEBUG_PUB.ADD('User_List count :'||USER_lIST.COUNT);
41: flags := CHECK_FLAG (

Line 39: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Use_List');

35: APPS_LIST := GENERATE_LIST_APPS;
36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);
38: USER_LIST := GENERATE_LIST_USER( P_LEVEL, P_VALUE );
39: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Use_List');
40: OE_DEBUG_PUB.ADD('User_List count :'||USER_lIST.COUNT);
41: flags := CHECK_FLAG (
42: value, value, value, value, value,
43: value, value, value, value, value,

Line 40: OE_DEBUG_PUB.ADD('User_List count :'||USER_lIST.COUNT);

36: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Apps_List');
37: OE_DEBUG_PUB.ADD('Apps_List count :'||APPS_lIST.COUNT);
38: USER_LIST := GENERATE_LIST_USER( P_LEVEL, P_VALUE );
39: OE_DEBUG_PUB.ADD('Validate_Main : Retrieved_Use_List');
40: OE_DEBUG_PUB.ADD('User_List count :'||USER_lIST.COUNT);
41: flags := CHECK_FLAG (
42: value, value, value, value, value,
43: value, value, value, value, value,
44: value, value, value, value, value,

Line 462: OE_DEBUG_PUB.ADD('Inside Get_Resp_List_For_Form : fn list count :');

458: l_form_name := p_form_name;
459: l_description := p_description;
460: l_application := p_application;
461: l_function_list := getFormFunctionId(l_form_name,l_application,l_description);
462: OE_DEBUG_PUB.ADD('Inside Get_Resp_List_For_Form : fn list count :');
463: OE_DEBUG_PUB.ADD(l_function_list.COUNT);
464: FOR k IN 1..l_function_list.COUNT
465: LOOP
466: l_function_id := l_function_list(k);

Line 463: OE_DEBUG_PUB.ADD(l_function_list.COUNT);

459: l_description := p_description;
460: l_application := p_application;
461: l_function_list := getFormFunctionId(l_form_name,l_application,l_description);
462: OE_DEBUG_PUB.ADD('Inside Get_Resp_List_For_Form : fn list count :');
463: OE_DEBUG_PUB.ADD(l_function_list.COUNT);
464: FOR k IN 1..l_function_list.COUNT
465: LOOP
466: l_function_id := l_function_list(k);
467: l_menu_list := getAllMenus(l_function_id);

Line 860: OE_DEBUG_PUB.ADD('In OEXRSTVB : Generate_List_Resp function');

856: prof_opt_id NUMBER := 1991;
857: oper_unit VARCHAR2(30);
858: ctr NUMBER := 1;
859: BEGIN
860: OE_DEBUG_PUB.ADD('In OEXRSTVB : Generate_List_Resp function');
861: list_so := getRespListForForm('OEXOEORD', 'Sales Orders', 'ONT');
862: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Sales Order form');
863: list_sh := getRespListForForm('WSHFSTRX', null, 'WSH' );
864: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Shipping Transactions form');

Line 862: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Sales Order form');

858: ctr NUMBER := 1;
859: BEGIN
860: OE_DEBUG_PUB.ADD('In OEXRSTVB : Generate_List_Resp function');
861: list_so := getRespListForForm('OEXOEORD', 'Sales Orders', 'ONT');
862: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Sales Order form');
863: list_sh := getRespListForForm('WSHFSTRX', null, 'WSH' );
864: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Shipping Transactions form');
865: list_qp := getRespListForForm('QPXPRLST', null, 'QP' );
866: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Price List form');

Line 864: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Shipping Transactions form');

860: OE_DEBUG_PUB.ADD('In OEXRSTVB : Generate_List_Resp function');
861: list_so := getRespListForForm('OEXOEORD', 'Sales Orders', 'ONT');
862: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Sales Order form');
863: list_sh := getRespListForForm('WSHFSTRX', null, 'WSH' );
864: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Shipping Transactions form');
865: list_qp := getRespListForForm('QPXPRLST', null, 'QP' );
866: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Price List form');
867: list_all := addArrayToArr(list_qp, addArrayToArr(list_so, list_sh));
868: IF P_LEVEL = 'INST' THEN

Line 866: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Price List form');

862: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Sales Order form');
863: list_sh := getRespListForForm('WSHFSTRX', null, 'WSH' );
864: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Shipping Transactions form');
865: list_qp := getRespListForForm('QPXPRLST', null, 'QP' );
866: OE_DEBUG_PUB.ADD('Retrieved responsibilities accessing Price List form');
867: list_all := addArrayToArr(list_qp, addArrayToArr(list_so, list_sh));
868: IF P_LEVEL = 'INST' THEN
869: RETURN getUniqueList(list_all);
870: END IF;

Line 1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');

1344: ---------------------------------------------------------
1345: --------- Other variables -------------------------------
1346: ---------------------------------------------------------
1347: begin
1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');
1349: OE_DEBUG_PUB.ADD('Input Paramters: ');
1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);
1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);
1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);

Line 1349: OE_DEBUG_PUB.ADD('Input Paramters: ');

1345: --------- Other variables -------------------------------
1346: ---------------------------------------------------------
1347: begin
1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');
1349: OE_DEBUG_PUB.ADD('Input Paramters: ');
1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);
1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);
1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);
1353: l_form_name := p_form_name;

Line 1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);

1346: ---------------------------------------------------------
1347: begin
1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');
1349: OE_DEBUG_PUB.ADD('Input Paramters: ');
1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);
1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);
1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);
1353: l_form_name := p_form_name;
1354: l_application := p_application;

Line 1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);

1347: begin
1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');
1349: OE_DEBUG_PUB.ADD('Input Paramters: ');
1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);
1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);
1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);
1353: l_form_name := p_form_name;
1354: l_application := p_application;
1355: l_description := p_description;

Line 1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);

1348: OE_DEBUG_PUB.ADD('IN OEXRSTVB: Get_Form_Function_Id');
1349: OE_DEBUG_PUB.ADD('Input Paramters: ');
1350: OE_DEBUG_PUB.ADD(' l_form_name: '||l_form_name);
1351: OE_DEBUG_PUB.ADD(' l_application: '||l_application);
1352: OE_DEBUG_PUB.ADD(' l_description: '||l_description);
1353: l_form_name := p_form_name;
1354: l_application := p_application;
1355: l_description := p_description;
1356: l_function_list.extend(l_sarray_init_lgt);

Line 1364: OE_DEBUG_PUB.ADD('l_form_id: '||l_form_id);

1360: select form_id
1361: into l_form_id
1362: from fnd_form
1363: where form_name = l_form_name;
1364: OE_DEBUG_PUB.ADD('l_form_id: '||l_form_id);
1365: ---------------------------------------------------------
1366: ---------- Application Id from Application Short Name --
1367: ---------------------------------------------------------
1368: select application_id

Line 1372: OE_DEBUG_PUB.ADD('l_application_id: '||l_application_id);

1368: select application_id
1369: into l_application_id
1370: from fnd_application
1371: where application_short_name = l_application;
1372: OE_DEBUG_PUB.ADD('l_application_id: '||l_application_id);
1373: ---------------------------------------------------------
1374: ---------- Process cursor to get function list ----------
1375: ---------------------------------------------------------
1376: open c_function_cursor(l_form_id);

Line 1377: OE_DEBUG_PUB.ADD('Opened Cursor c_function_cursor');

1373: ---------------------------------------------------------
1374: ---------- Process cursor to get function list ----------
1375: ---------------------------------------------------------
1376: open c_function_cursor(l_form_id);
1377: OE_DEBUG_PUB.ADD('Opened Cursor c_function_cursor');
1378: fetch c_function_cursor into l_function_csr;
1379: OE_DEBUG_PUB.ADD('Fetched cursor into l_function_csr');
1380: if ( c_function_cursor%NOTFOUND ) then
1381: OE_DEBUG_PUB.ADD('No records in cursor');

Line 1379: OE_DEBUG_PUB.ADD('Fetched cursor into l_function_csr');

1375: ---------------------------------------------------------
1376: open c_function_cursor(l_form_id);
1377: OE_DEBUG_PUB.ADD('Opened Cursor c_function_cursor');
1378: fetch c_function_cursor into l_function_csr;
1379: OE_DEBUG_PUB.ADD('Fetched cursor into l_function_csr');
1380: if ( c_function_cursor%NOTFOUND ) then
1381: OE_DEBUG_PUB.ADD('No records in cursor');
1382: l_empty_cursor := true;
1383: else

Line 1381: OE_DEBUG_PUB.ADD('No records in cursor');

1377: OE_DEBUG_PUB.ADD('Opened Cursor c_function_cursor');
1378: fetch c_function_cursor into l_function_csr;
1379: OE_DEBUG_PUB.ADD('Fetched cursor into l_function_csr');
1380: if ( c_function_cursor%NOTFOUND ) then
1381: OE_DEBUG_PUB.ADD('No records in cursor');
1382: l_empty_cursor := true;
1383: else
1384: OE_DEBUG_PUB.ADD('records found in cursor');
1385: l_csr_app_id:=l_function_csr.application_id;

Line 1384: OE_DEBUG_PUB.ADD('records found in cursor');

1380: if ( c_function_cursor%NOTFOUND ) then
1381: OE_DEBUG_PUB.ADD('No records in cursor');
1382: l_empty_cursor := true;
1383: else
1384: OE_DEBUG_PUB.ADD('records found in cursor');
1385: l_csr_app_id:=l_function_csr.application_id;
1386: OE_DEBUG_PUB.ADD('l_csr_app_id :'||l_csr_app_id);
1387: if (l_csr_app_id=l_application_id) then
1388: loop

Line 1386: OE_DEBUG_PUB.ADD('l_csr_app_id :'||l_csr_app_id);

1382: l_empty_cursor := true;
1383: else
1384: OE_DEBUG_PUB.ADD('records found in cursor');
1385: l_csr_app_id:=l_function_csr.application_id;
1386: OE_DEBUG_PUB.ADD('l_csr_app_id :'||l_csr_app_id);
1387: if (l_csr_app_id=l_application_id) then
1388: loop
1389: l_function_list(l_list_index):=l_function_csr.function_id;
1390: l_list_index:=l_list_index+1;