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.OKL_SUBSIDY_POOL_PVT dependencies on OKL_DEBUG_PUB

Line 141: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

137: -------------------
138:
139:
140: BEGIN
141: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
142: IF(L_DEBUG_ENABLED='Y') THEN
143: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
145: END IF;

Line 144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

140: BEGIN
141: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
142: IF(L_DEBUG_ENABLED='Y') THEN
143: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
145: END IF;
146: IF(IS_DEBUG_PROCEDURE_ON) THEN
147: BEGIN
148: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');

Line 148: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');

144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
145: END IF;
146: IF(IS_DEBUG_PROCEDURE_ON) THEN
147: BEGIN
148: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
149: END;
150: END IF;
151:
152: l_sub_pool_rec := p_sub_pool_rec;

Line 212: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');

208: x_msg_count := l_msg_count;
209:
210: IF(IS_DEBUG_PROCEDURE_ON) THEN
211: BEGIN
212: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
213: END;
214: END IF;
215:
216: EXCEPTION

Line 326: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

322:
323:
324:
325: BEGIN
326: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
327: IF(L_DEBUG_ENABLED='Y') THEN
328: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
330: END IF;

Line 329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

325: BEGIN
326: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
327: IF(L_DEBUG_ENABLED='Y') THEN
328: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
330: END IF;
331: IF(IS_DEBUG_PROCEDURE_ON) THEN
332: BEGIN
333: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

Line 333: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
330: END IF;
331: IF(IS_DEBUG_PROCEDURE_ON) THEN
332: BEGIN
333: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
334: END;
335: END IF;
336: l_sub_pool_rec := p_sub_pool_rec;
337: l_effective_to_date := l_sub_pool_rec.effective_to_date;

Line 449: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

445: x_msg_count := l_msg_count;
446:
447: IF(IS_DEBUG_PROCEDURE_ON) THEN
448: BEGIN
449: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
450: END;
451: END IF;
452:
453: EXCEPTION

Line 538: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

534: -- irrespective of the calling procedure.
535:
536: PRAGMA AUTONOMOUS_TRANSACTION;
537: BEGIN
538: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
539: IF(L_DEBUG_ENABLED='Y') THEN
540: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
542: END IF;

Line 541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

537: BEGIN
538: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
539: IF(L_DEBUG_ENABLED='Y') THEN
540: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
542: END IF;
543: IF(IS_DEBUG_PROCEDURE_ON) THEN
544: BEGIN
545: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

Line 545: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
542: END IF;
543: IF(IS_DEBUG_PROCEDURE_ON) THEN
544: BEGIN
545: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
546: END;
547: END IF;
548: l_subsidy_pool_id := p_subsidy_pool_id;
549: l_row_found := FALSE;

Line 600: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

596:
597: COMMIT;
598: IF(IS_DEBUG_PROCEDURE_ON) THEN
599: BEGIN
600: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
601: END;
602: END IF;
603:
604: EXCEPTION

Line 685: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

681: -- DECLARE Cursors
682: -------------------
683:
684: BEGIN
685: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
686: IF(L_DEBUG_ENABLED='Y') THEN
687: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
689: END IF;

Line 688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

684: BEGIN
685: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
686: IF(L_DEBUG_ENABLED='Y') THEN
687: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
689: END IF;
690: IF(IS_DEBUG_PROCEDURE_ON) THEN
691: BEGIN
692: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

Line 692: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
689: END IF;
690: IF(IS_DEBUG_PROCEDURE_ON) THEN
691: BEGIN
692: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
693: END;
694: END IF;
695: l_subsidy_pool_id := p_subsidy_pool_id;
696: l_row_found := FALSE;

Line 745: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

741: x_msg_count := l_msg_count;
742:
743: IF(IS_DEBUG_PROCEDURE_ON) THEN
744: BEGIN
745: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
746: END;
747: END IF;
748:
749: EXCEPTION

Line 831: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

827: -- DECLARE Cursors
828: -------------------
829:
830: BEGIN
831: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
832: IF(L_DEBUG_ENABLED='Y') THEN
833: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
835: END IF;

Line 834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

830: BEGIN
831: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
832: IF(L_DEBUG_ENABLED='Y') THEN
833: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
835: END IF;
836: IF(IS_DEBUG_PROCEDURE_ON) THEN
837: BEGIN
838: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

Line 838: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
835: END IF;
836: IF(IS_DEBUG_PROCEDURE_ON) THEN
837: BEGIN
838: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
839: END;
840: END IF;
841: l_subsidy_pool_id := p_subsidy_pool_id;
842: l_row_found := FALSE;

Line 890: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

886: x_msg_count := l_msg_count;
887:
888: IF(IS_DEBUG_PROCEDURE_ON) THEN
889: BEGIN
890: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
891: END;
892: END IF;
893:
894: EXCEPTION

Line 978: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

974: -- DECLARE Cursors
975: -------------------
976:
977: BEGIN
978: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
979: IF(L_DEBUG_ENABLED='Y') THEN
980: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
982: END IF;

Line 981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

977: BEGIN
978: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
979: IF(L_DEBUG_ENABLED='Y') THEN
980: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
982: END IF;
983: IF(IS_DEBUG_PROCEDURE_ON) THEN
984: BEGIN
985: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

Line 985: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
982: END IF;
983: IF(IS_DEBUG_PROCEDURE_ON) THEN
984: BEGIN
985: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
986: END;
987: END IF;
988: l_subsidy_pool_id := p_subsidy_pool_id;
989: l_row_found := FALSE;

Line 1061: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');

1057: x_msg_count := l_msg_count;
1058:
1059: IF(IS_DEBUG_PROCEDURE_ON) THEN
1060: BEGIN
1061: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
1062: END;
1063: END IF;
1064:
1065: EXCEPTION

Line 1136: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

1132: l_return_status VARCHAR2(1) ;
1133: l_sub_pool_rec subsidy_pool_rec ;
1134:
1135: BEGIN
1136: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
1137: IF(L_DEBUG_ENABLED='Y') THEN
1138: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1140: END IF;

Line 1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

1135: BEGIN
1136: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
1137: IF(L_DEBUG_ENABLED='Y') THEN
1138: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1140: END IF;
1141: IF(IS_DEBUG_PROCEDURE_ON) THEN
1142: BEGIN
1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');

Line 1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');

1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1140: END IF;
1141: IF(IS_DEBUG_PROCEDURE_ON) THEN
1142: BEGIN
1143: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');
1144: END;
1145: END IF;
1146: l_api_version := 1.0;
1147: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1191: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');

1187: x_msg_data => x_msg_data);
1188:
1189: IF(IS_DEBUG_PROCEDURE_ON) THEN
1190: BEGIN
1191: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.validate_row ');
1192: END;
1193: END IF;
1194:
1195: EXCEPTION