DBA Data[Home] [Help]

APPS.IGC_CC_INT_CC_REL_PUB dependencies on FND_LOG

Line 9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;

5: -- g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
6: g_debug_mode VARCHAR2 (1)
7: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
8: --Variables for ATG Central logging
9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;

Line 10: g_state_level NUMBER := fnd_log.level_statement;

6: g_debug_mode VARCHAR2 (1)
7: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
8: --Variables for ATG Central logging
9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;

Line 11: g_proc_level NUMBER := fnd_log.level_procedure;

7: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
8: --Variables for ATG Central logging
9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;
15: g_unexp_level NUMBER := fnd_log.level_unexpected;

Line 12: g_event_level NUMBER := fnd_log.level_event;

8: --Variables for ATG Central logging
9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;
15: g_unexp_level NUMBER := fnd_log.level_unexpected;
16: g_path VARCHAR2 (255)

Line 13: g_excep_level NUMBER := fnd_log.level_exception;

9: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;
15: g_unexp_level NUMBER := fnd_log.level_unexpected;
16: g_path VARCHAR2 (255)
17: := 'IGC.PLSQL.IGCCICRB.IGC_CC_INT_CC_REL_PUB.';

Line 14: g_error_level NUMBER := fnd_log.level_error;

10: g_state_level NUMBER := fnd_log.level_statement;
11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;
15: g_unexp_level NUMBER := fnd_log.level_unexpected;
16: g_path VARCHAR2 (255)
17: := 'IGC.PLSQL.IGCCICRB.IGC_CC_INT_CC_REL_PUB.';
18:

Line 15: g_unexp_level NUMBER := fnd_log.level_unexpected;

11: g_proc_level NUMBER := fnd_log.level_procedure;
12: g_event_level NUMBER := fnd_log.level_event;
13: g_excep_level NUMBER := fnd_log.level_exception;
14: g_error_level NUMBER := fnd_log.level_error;
15: g_unexp_level NUMBER := fnd_log.level_unexpected;
16: g_path VARCHAR2 (255)
17: := 'IGC.PLSQL.IGCCICRB.IGC_CC_INT_CC_REL_PUB.';
18:
19: --

Line 77: fnd_log.STRING (g_state_level, p_path, p_debug_msg);

73: raise FND_API.G_EXC_ERROR;
74: END IF;*/
75: IF (g_state_level >= g_debug_level)
76: THEN
77: fnd_log.STRING (g_state_level, p_path, p_debug_msg);
78: END IF;
79:
80: RETURN;
81: -- --------------------------------------------------------------------

Line 243: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

239: fnd_message.set_name ('IGC', 'IGC_CC_NO_ORG_ID');
240:
241: IF (g_error_level >= g_debug_level)
242: THEN
243: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
244: END IF;
245:
246: fnd_msg_pub.ADD;
247: RAISE e_null_parameter;

Line 256: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

252: fnd_message.set_name ('IGC', 'IGC_CC_NO_SOB');
253:
254: IF (g_error_level >= g_debug_level)
255: THEN
256: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
257: END IF;
258:
259: fnd_msg_pub.ADD;
260: RAISE e_null_parameter;

Line 271: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

267: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_SUP');
268:
269: IF (g_error_level >= g_debug_level)
270: THEN
271: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
272: END IF;
273:
274: fnd_msg_pub.ADD;
275: RAISE e_int_rel_no_sup;

Line 284: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

280: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_INV');
281:
282: IF (g_error_level >= g_debug_level)
283: THEN
284: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
285: END IF;
286:
287: fnd_msg_pub.ADD;
288: RAISE e_int_rel_no_inv;

Line 297: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

293: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_CC');
294:
295: IF (g_error_level >= g_debug_level)
296: THEN
297: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
298: END IF;
299:
300: fnd_msg_pub.ADD;
301: RAISE e_int_rel_no_cover_cc;

Line 319: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

315: fnd_message.set_token ('USER_ID', TO_CHAR (p_user_id), TRUE);
316:
317: IF (g_excep_level >= g_debug_level)
318: THEN
319: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
320: END IF;
321:
322: fnd_msg_pub.ADD;
323: RAISE e_int_rel_invalid_user_id;

Line 332: FROM fnd_logins

328: THEN
329: BEGIN
330: SELECT login_id
331: INTO l_login_id
332: FROM fnd_logins
333: WHERE login_id = p_login_id;
334: EXCEPTION
335: WHEN NO_DATA_FOUND
336: THEN

Line 342: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

338: fnd_message.set_token ('LOGIN_ID', TO_CHAR (p_login_id), TRUE);
339:
340: IF (g_excep_level >= g_debug_level)
341: THEN
342: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
343: END IF;
344:
345: fnd_msg_pub.ADD;
346: RAISE e_int_rel_invalid_login_id;

Line 370: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

366: fnd_msg_pub.ADD;
367:
368: IF (g_excep_level >= g_debug_level)
369: THEN
370: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
371: END IF;
372:
373: RAISE e_int_rel_no_inv;
374: END;

Line 388: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

384: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_COVER_INFO');
385:
386: IF (g_excep_level >= g_debug_level)
387: THEN
388: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
389: END IF;
390:
391: fnd_msg_pub.ADD;
392: RAISE e_int_rel_no_cover_cc;

Line 407: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

403: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_COVER_AMT');
404:
405: IF (g_excep_level >= g_debug_level)
406: THEN
407: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
408: END IF;
409:
410: fnd_msg_pub.ADD;
411: RAISE e_int_rel_no_cover_cc;

Line 427: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

423: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_REL_AMT');
424:
425: IF (g_excep_level >= g_debug_level)
426: THEN
427: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
428: END IF;
429:
430: fnd_msg_pub.ADD;
431: RAISE e_int_rel_no_cover_cc;

Line 458: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);

454: fnd_message.set_name ('IGC', 'IGC_CC_INT_REL_NO_AVAIL_AMT');
455:
456: IF (g_error_level >= g_debug_level)
457: THEN
458: fnd_log.MESSAGE (g_error_level, l_full_path, FALSE);
459: END IF;
460:
461: fnd_msg_pub.ADD;
462: RAISE e_int_rel_no_cover_cc;

Line 485: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

481: fnd_message.set_name ('IGC', 'IGC_CC_NUM_METHOD_NOT_DEFINED');
482:
483: IF (g_excep_level >= g_debug_level)
484: THEN
485: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
486: END IF;
487:
488: fnd_msg_pub.ADD;
489: RAISE e_int_rel_no_num_method;

Line 912: fnd_log.STRING

908: );
909:
910: IF (g_excep_level >= g_debug_level)
911: THEN
912: fnd_log.STRING
913: (g_excep_level,
914: l_full_path,
915: 'E_INT_REL_NO_SUP or E_INT_REL_NO_INV or E_INT_REL_NO_COVER_CC'
916: || ' or E_INT_REL_NO_NUM_METHOD or E_INT_REL_NO_NUM_METHOD or E_INT_REL_INVALID_USER_ID or E_INT_REL_INVALID_LOGIN_ID'

Line 948: fnd_log.STRING (g_excep_level,

944: );
945:
946: IF (g_excep_level >= g_debug_level)
947: THEN
948: fnd_log.STRING (g_excep_level,
949: l_full_path,
950: 'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised'
951: );
952: END IF;

Line 991: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);

987: THEN
988: fnd_message.set_name ('IGC', 'IGC_LOGGING_UNEXP_ERROR');
989: fnd_message.set_token ('CODE', SQLCODE);
990: fnd_message.set_token ('MSG', SQLERRM);
991: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);
992: END IF;
993: END create_releases;
994:
995: PROCEDURE release_cc_num (

Line 1031: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

1027: fnd_message.set_name ('IGC', 'IGC_CC_NO_UPD_CC_NEXT_NUM');
1028:
1029: IF (g_excep_level >= g_debug_level)
1030: THEN
1031: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1032: END IF;
1033:
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_error;

Line 1055: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);

1051: THEN
1052: fnd_message.set_name ('IGC', 'IGC_LOGGING_UNEXP_ERROR');
1053: fnd_message.set_token ('CODE', SQLCODE);
1054: fnd_message.set_token ('MSG', SQLERRM);
1055: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);
1056: END IF;
1057:
1058: RETURN;
1059: END release_cc_num;

Line 1082: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

1078: fnd_message.set_name ('IGC', 'IGC_CC_NO_CC_HDR_SEQ');
1079:
1080: IF (g_excep_level >= g_debug_level)
1081: THEN
1082: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1083: END IF;
1084:
1085: fnd_msg_pub.ADD;
1086: RAISE fnd_api.g_exc_error;

Line 1105: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);

1101: THEN
1102: fnd_message.set_name ('IGC', 'IGC_LOGGING_UNEXP_ERROR');
1103: fnd_message.set_token ('CODE', SQLCODE);
1104: fnd_message.set_token ('MSG', SQLERRM);
1105: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);
1106: END IF;
1107:
1108: RETURN;
1109: END release_cc_header_id;

Line 1132: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

1128: fnd_message.set_name ('IGC', 'IGC_CC_NO_CC_ACCT_SEQ');
1129:
1130: IF (g_excep_level >= g_debug_level)
1131: THEN
1132: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1133: END IF;
1134:
1135: fnd_msg_pub.ADD;
1136: RAISE fnd_api.g_exc_error;

Line 1155: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);

1151: THEN
1152: fnd_message.set_name ('IGC', 'IGC_LOGGING_UNEXP_ERROR');
1153: fnd_message.set_token ('CODE', SQLCODE);
1154: fnd_message.set_token ('MSG', SQLERRM);
1155: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);
1156: END IF;
1157:
1158: RETURN;
1159: END release_cc_acct_line_id;

Line 1182: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);

1178: fnd_message.set_name ('IGC', 'IGC_CC_NO_CC_DET_PF_SEQ');
1179:
1180: IF (g_excep_level >= g_debug_level)
1181: THEN
1182: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1183: END IF;
1184:
1185: fnd_msg_pub.ADD;
1186: RAISE fnd_api.g_exc_error;

Line 1205: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);

1201: THEN
1202: fnd_message.set_name ('IGC', 'IGC_LOGGING_UNEXP_ERROR');
1203: fnd_message.set_token ('CODE', SQLCODE);
1204: fnd_message.set_token ('MSG', SQLERRM);
1205: fnd_log.MESSAGE (g_unexp_level, l_full_path, TRUE);
1206: END IF;
1207:
1208: RETURN;
1209: END release_cc_det_pf_line_id;