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.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_MSGS_PKG

Line 459: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(p_debug_flag);

455: -- --------------------------------------------------------------------
456: -- Initialize Return status and other local variables.
457: -- --------------------------------------------------------------------
458: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
459: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(p_debug_flag);
460: g_update_login := FND_GLOBAL.LOGIN_ID;
461: g_update_by := FND_GLOBAL.USER_ID;
462: g_mode := p_mode;
463: g_last_activity_date := p_last_activity_date;

Line 483: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

479: -- --------------------------------------------------------------------
480: -- Initialize debug information if the user has requested debug to
481: -- be turned on.
482: -- --------------------------------------------------------------------
483: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
484: IF (g_debug_mode = 'Y') THEN
485: g_debug_msg := ' ************ Starting ARCHIVE / PURGE CC '||
486: to_char(sysdate,'DD-MON-YY:MI:SS') || ' *************************';
487: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 534: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

530: IF (NOT g_validation_error) THEN
531:
532: IF (g_mode = 'AR') THEN
533:
534: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
535: IF (g_debug_mode = 'Y') THEN
536: g_debug_msg := ' Calling Procedure to Archive for Last Activity Date : ' ||
537: g_last_activity_date;
538: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 554: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

550: -- records to be purged will be for NON MRC and MRC records.
551: -- --------------------------------------------------------------------
552: ELSIF (g_mode = 'PU') THEN
553:
554: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
555: IF (g_debug_mode = 'Y') THEN
556: g_debug_msg := ' Calling Procedure to Purge for Last Activity Date : ' ||
557: g_last_activity_date;
558: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 571: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

567: END IF;
568:
569: ELSE
570:
571: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
572: IF (g_debug_mode = 'Y') THEN
573: g_debug_msg := ' Validation error happened for Last Activity Date : ' ||
574: g_last_activity_date;
575: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 837: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

833: -- Initialize Return status and other local variables.
834: -- --------------------------------------------------------------------
835: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
836:
837: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
838: IF (g_debug_mode = 'Y') THEN
839: g_debug_msg := ' Beginning Archive process for Last Activity Date : ' ||
840: g_last_activity_date;
841: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 857: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

853: END IF;
854:
855: ELSE
856:
857: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
858: IF (g_debug_mode = 'Y') THEN
859: g_debug_msg := ' NOT deleting records from Archive MRC tables for' ||
860: ' Last Activity Date : ' || g_last_activity_date;
861: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 893: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

889: END IF;
890:
891: ELSE
892:
893: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
894: IF (g_debug_mode = 'Y') THEN
895: g_debug_msg := ' NOT Archiving records from MRC tables for' ||
896: ' Last Activity Date : ' || g_last_activity_date;
897: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1011: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1007: ( SELECT ICV.cc_header_id
1008: FROM igc_arc_pur_candidates ICV
1009: );
1010:
1011: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1012: IF (g_debug_mode = 'Y') THEN
1013: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in MC Headers Table for ' ||
1014: ' Last Activity Date : ' || g_last_activity_date;
1015: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1045: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1041: ( SELECT ICV.cc_header_id
1042: FROM igc_arc_pur_candidates ICV
1043: );
1044:
1045: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1046: IF (g_debug_mode = 'Y') THEN
1047: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in MC Headers Hist Table for ' ||
1048: ' Last Activity Date : ' || g_last_activity_date;
1049: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1094: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1090: FROM igc_arc_pur_candidates ICV2
1091: )
1092: );
1093:
1094: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1095: IF (g_debug_mode = 'Y') THEN
1096: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in MC Acct Line Table for ' ||
1097: ' Last Activity Date : ' || g_last_activity_date;
1098: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1146: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1142: FROM igc_arc_pur_candidates ICV2
1143: )
1144: );
1145:
1146: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1147: IF (g_debug_mode = 'Y') THEN
1148: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in MC Acct Line Hist Table for ' ||
1149: ' Last Activity Date : ' || g_last_activity_date;
1150: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1217: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1213: )
1214: )
1215: );
1216:
1217: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1218: IF (g_debug_mode = 'Y') THEN
1219: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in MC Det PF Table for ' ||
1220: ' Last Activity Date : ' || g_last_activity_date;
1221: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1291: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1287: )
1288: )
1289: );
1290:
1291: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1292: IF (g_debug_mode = 'Y') THEN
1293: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into MC Det PF Hist Table for ' ||
1294: ' Last Activity Date : ' || g_last_activity_date;
1295: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1479: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1475: ( SELECT cc_header_id
1476: FROM igc_arc_pur_candidates
1477: );
1478:
1479: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1480: IF (g_debug_mode = 'Y') THEN
1481: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows in Headers Table for ' ||
1482: ' Last Activity Date : ' || g_last_activity_date;
1483: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1601: ( SELECT cc_header_id
1602: FROM igc_arc_pur_candidates
1603: );
1604:
1605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1606: IF (g_debug_mode = 'Y') THEN
1607: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Headers Hist Table for ' ||
1608: ' Last Activity Date : ' || g_last_activity_date;
1609: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1719: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1715: ( SELECT ICV1.cc_header_id
1716: FROM igc_arc_pur_candidates ICV1
1717: );
1718:
1719: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1720: IF (g_debug_mode = 'Y') THEN
1721: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Acct Line Table for ' ||
1722: ' Last Activity Date : ' || g_last_activity_date;
1723: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1836: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1832: ( SELECT ICV1.cc_header_id
1833: FROM igc_arc_pur_candidates ICV1
1834: );
1835:
1836: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1837: IF (g_debug_mode = 'Y') THEN
1838: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Acct Line Hist Table for ' ||
1839: ' Last Activity Date : ' || g_last_activity_date;
1840: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 1937: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

1933: FROM igc_arc_pur_candidates ICV2
1934: )
1935: );
1936:
1937: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
1938: IF (g_debug_mode = 'Y') THEN
1939: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Det PF Table for ' ||
1940: ' Last Activity Date : ' || g_last_activity_date;
1941: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2041: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

2037: FROM igc_arc_pur_candidates ICV2
2038: )
2039: );
2040:
2041: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2042: IF (g_debug_mode = 'Y') THEN
2043: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Det PF Hist Table for ' ||
2044: ' Last Activity Date : ' || g_last_activity_date;
2045: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2087: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

2083: ( SELECT ICV.cc_header_id
2084: FROM igc_arc_pur_candidates ICV
2085: );
2086:
2087: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2088: IF (g_debug_mode = 'Y') THEN
2089: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into Actions Table for ' ||
2090: ' Last Activity Date : ' || g_last_activity_date;
2091: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2365: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

2361: FROM igc_arc_pur_candidates ICV
2362: );
2363: -- );
2364:
2365: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2366: IF (g_debug_mode = 'Y') THEN
2367: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Headers ALL Table for ' ||
2368: ' Last Activity Date : ' || g_last_activity_date;
2369: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

2601: FROM igc_arc_pur_candidates ICV
2602: )
2603: );
2604:
2605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2606: IF (g_debug_mode = 'Y') THEN
2607: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Lines ALL Table for ' ||
2608: ' Last Activity Date : ' || g_last_activity_date;
2609: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 2869: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

2865: FROM igc_arc_pur_candidates ICV
2866: )
2867: );
2868:
2869: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2870: IF (g_debug_mode = 'Y') THEN
2871: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Line Loc ALL Table for ' ||
2872: ' Last Activity Date : ' || g_last_activity_date;
2873: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3071: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3067: FROM igc_arc_pur_candidates ICV
3068: )
3069: );
3070:
3071: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3072: IF (g_debug_mode = 'Y') THEN
3073: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Dist ALL Table for ' ||
3074: ' Last Activity Date : ' || g_last_activity_date;
3075: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3152: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3148: -- Initialize local variables.
3149: -- --------------------------------------------------------------------
3150: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3151:
3152: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3153: IF (g_debug_mode = 'Y') THEN
3154: g_debug_msg := ' Building the Candidate List......';
3155: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3156: END IF;

Line 3206: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3202: AND AIA1.cancelled_date IS NULL
3203: );
3204:
3205: IF (SQL%ROWCOUNT <= 0) THEN
3206: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3207: IF (g_debug_mode = 'Y') THEN
3208: g_debug_msg := ' No Candidates Found to be inserted into table......';
3209: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3210: END IF;

Line 3212: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

3208: g_debug_msg := ' No Candidates Found to be inserted into table......';
3209: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3210: END IF;
3211:
3212: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
3213: p_tokval => g_sob_id);
3214: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
3215: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
3216: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 3214: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',

3210: END IF;
3211:
3212: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
3213: p_tokval => g_sob_id);
3214: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
3215: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
3216: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
3217: p_msgname => 'IGC_NO_ARC_PUR_CANDIDATES');
3218: g_validation_error := TRUE;

Line 3216: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

3212: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
3213: p_tokval => g_sob_id);
3214: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
3215: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
3216: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
3217: p_msgname => 'IGC_NO_ARC_PUR_CANDIDATES');
3218: g_validation_error := TRUE;
3219: ELSE
3220:

Line 3267: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3263: CLOSE c_cand_count;
3264:
3265: IF (l_count <= 0) THEN
3266: g_validation_error := TRUE;
3267: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3268: IF (g_debug_mode = 'Y') THEN
3269: g_debug_msg := ' No Candidates Found to be inserted into table......';
3270: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3271: END IF;

Line 3369: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3365: n_mrc_enabled => g_mrc_installed);
3366:
3367: IF (g_mrc_installed <> 'Y') THEN
3368: g_mrc_installed := 'N';
3369: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3370: IF (g_debug_mode = 'Y') THEN
3371: g_debug_msg := ' MRC is NOT installed thus NOT enabled';
3372: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3373: END IF;

Line 3375: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3371: g_debug_msg := ' MRC is NOT installed thus NOT enabled';
3372: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3373: END IF;
3374: ELSE
3375: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3376: IF (g_debug_mode = 'Y') THEN
3377: g_debug_msg := ' MRC is installed so will be checking for ENABLED.';
3378: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3379: END IF;

Line 3448: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3444:
3445: -- --------------------------------------------------------------------
3446: -- Delete MRC Archive Header records before adding again.
3447: -- --------------------------------------------------------------------
3448: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3449: IF (g_debug_mode = 'Y') THEN
3450: g_debug_msg := ' Deleting records from Archive MRC Headers table for' ||
3451: ' Last Activity Date : ' || g_last_activity_date;
3452: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3465: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3461:
3462: -- --------------------------------------------------------------------
3463: -- Delete MRC Archive Account Line records before adding again.
3464: -- --------------------------------------------------------------------
3465: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3466: IF (g_debug_mode = 'Y') THEN
3467: g_debug_msg := ' Deleting records from Archive MRC Acct Lines table for' ||
3468: ' Last Activity Date : ' || g_last_activity_date;
3469: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3494: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3490:
3491: -- --------------------------------------------------------------------
3492: -- Delete MRC Archive Detail Payment Forcast records before adding again.
3493: -- --------------------------------------------------------------------
3494: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3495: IF (g_debug_mode = 'Y') THEN
3496: g_debug_msg := ' Deleting records from Archive MRC DET PF table for' ||
3497: ' Last Activity Date : ' || g_last_activity_date;
3498: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3547: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3543:
3544: -- --------------------------------------------------------------------
3545: -- Delete MRC Archive Header History records before adding again.
3546: -- --------------------------------------------------------------------
3547: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3548: IF (g_debug_mode = 'Y') THEN
3549: g_debug_msg := ' Deleting records from Archive MRC Header History table for' ||
3550: ' Last Activity Date : ' || g_last_activity_date;
3551: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3564: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3560:
3561: -- --------------------------------------------------------------------
3562: -- Delete MRC Archive Account Line History records before adding again.
3563: -- --------------------------------------------------------------------
3564: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3565: IF (g_debug_mode = 'Y') THEN
3566: g_debug_msg := ' Deleting records from Archive MRC Acct Line History table for' ||
3567: ' Last Activity Date : ' || g_last_activity_date;
3568: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3593: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3589:
3590: -- --------------------------------------------------------------------
3591: -- Delete MRC Archive Payment Forcast History records before adding again.
3592: -- --------------------------------------------------------------------
3593: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3594: IF (g_debug_mode = 'Y') THEN
3595: g_debug_msg := ' Deleting records from Archive MRC DET PF History table for' ||
3596: ' Last Activity Date : ' || g_last_activity_date;
3597: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3709: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3705:
3706: -- --------------------------------------------------------------------
3707: -- Delete Archive Header records before adding again.
3708: -- --------------------------------------------------------------------
3709: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3710: IF (g_debug_mode = 'Y') THEN
3711: g_debug_msg := ' Deleting records from Archive Headers table for' ||
3712: ' Last Activity Date : ' || g_last_activity_date;
3713: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3726: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3722:
3723: -- --------------------------------------------------------------------
3724: -- Delete Archive Header History records before adding again.
3725: -- --------------------------------------------------------------------
3726: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3727: IF (g_debug_mode = 'Y') THEN
3728: g_debug_msg := ' Deleting records from Archive Headers History table for' ||
3729: ' Last Activity Date : ' || g_last_activity_date;
3730: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3743: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3739:
3740: -- --------------------------------------------------------------------
3741: -- Delete Archive Account Line records before adding again.
3742: -- --------------------------------------------------------------------
3743: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3744: IF (g_debug_mode = 'Y') THEN
3745: g_debug_msg := ' Deleting records from Archive Acct Lines table for' ||
3746: ' Last Activity Date : ' || g_last_activity_date;
3747: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3760: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3756:
3757: -- --------------------------------------------------------------------
3758: -- Delete Archive Account Line History records before adding again.
3759: -- --------------------------------------------------------------------
3760: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3761: IF (g_debug_mode = 'Y') THEN
3762: g_debug_msg := ' Deleting records from Archive Acct Lines History table for' ||
3763: ' Last Activity Date : ' || g_last_activity_date;
3764: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3777: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3773:
3774: -- --------------------------------------------------------------------
3775: -- Delete Archive Payment Forcast records before adding again.
3776: -- --------------------------------------------------------------------
3777: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3778: IF (g_debug_mode = 'Y') THEN
3779: g_debug_msg := ' Deleting records from Archive MRC DET PF table for' ||
3780: ' Last Activity Date : ' || g_last_activity_date;
3781: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3806: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3802:
3803: -- --------------------------------------------------------------------
3804: -- Delete Archive Payment Forcast History records before adding again.
3805: -- --------------------------------------------------------------------
3806: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3807: IF (g_debug_mode = 'Y') THEN
3808: g_debug_msg := ' Deleting records from Archive MRC DET PF History table for' ||
3809: ' Last Activity Date : ' || g_last_activity_date;
3810: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3835: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3831:
3832: -- --------------------------------------------------------------------
3833: -- Delete Archive Action records before adding again.
3834: -- --------------------------------------------------------------------
3835: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3836: IF (g_debug_mode = 'Y') THEN
3837: g_debug_msg := ' Deleting records from Archive Actions table for' ||
3838: ' Last Activity Date : ' || g_last_activity_date;
3839: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3852: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3848:
3849: -- --------------------------------------------------------------------
3850: -- Delete Archived PO Header records that may exist
3851: -- --------------------------------------------------------------------
3852: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3853: IF (g_debug_mode = 'Y') THEN
3854: g_debug_msg := ' Deleting records from Archive PO Headers table for' ||
3855: ' Last Activity Date : ' || g_last_activity_date;
3856: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3873: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3869:
3870: -- --------------------------------------------------------------------
3871: -- Delete Archived PO Line records that may exist
3872: -- --------------------------------------------------------------------
3873: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3874: IF (g_debug_mode = 'Y') THEN
3875: g_debug_msg := ' Deleting records from Archive PO Lines table for' ||
3876: ' Last Activity Date : ' || g_last_activity_date;
3877: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3894: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3890:
3891: -- --------------------------------------------------------------------
3892: -- Delete Archived PO Line Location records that may exist
3893: -- --------------------------------------------------------------------
3894: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3895: IF (g_debug_mode = 'Y') THEN
3896: g_debug_msg := ' Deleting records from Archive PO Line Locations table for' ||
3897: ' Last Activity Date : ' || g_last_activity_date;
3898: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 3915: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

3911:
3912: -- --------------------------------------------------------------------
3913: -- Delete Archived PO Distribution records that may exist
3914: -- --------------------------------------------------------------------
3915: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3916: IF (g_debug_mode = 'Y') THEN
3917: g_debug_msg := ' Deleting records from Archive PO Distributions table for' ||
3918: ' Last Activity Date : ' || g_last_activity_date;
3919: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4038: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4034: -- Initialize Return status and other local variables.
4035: -- --------------------------------------------------------------------
4036: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4037:
4038: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4039: IF (g_debug_mode = 'Y') THEN
4040: g_debug_msg := ' Initializing History Record for Archive / Purge Process';
4041: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4042: END IF;

Line 4129: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4125: p_History_Rec.creation_date := SYSDATE;
4126:
4127: ELSE
4128:
4129: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4130: IF (g_debug_mode = 'Y') THEN
4131: g_debug_msg := ' Not allowed to initialize history record as not found in History Table';
4132: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4133: g_debug_msg := ' and activity is not archive. CC Header id : ' || p_cc_header_id;

Line 4137: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

4133: g_debug_msg := ' and activity is not archive. CC Header id : ' || p_cc_header_id;
4134: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4135: END IF;
4136:
4137: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4138: p_tokval => g_sob_id);
4139: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4140: p_tokval => p_cc_header_id);
4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 4139: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

4135: END IF;
4136:
4137: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4138: p_tokval => g_sob_id);
4139: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4140: p_tokval => p_cc_header_id);
4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4142: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4143: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

4137: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4138: p_tokval => g_sob_id);
4139: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4140: p_tokval => p_cc_header_id);
4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4142: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4143: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4144: p_tokval => 'CC');
4145: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 4143: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

4139: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4140: p_tokval => p_cc_header_id);
4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4142: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4143: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4144: p_tokval => 'CC');
4145: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4146: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
4147: raise FND_API.G_EXC_ERROR;

Line 4145: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

4141: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4142: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4143: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4144: p_tokval => 'CC');
4145: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4146: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
4147: raise FND_API.G_EXC_ERROR;
4148:
4149: END IF;

Line 4271: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4267: -- Initialize Return status and other local variables.
4268: -- --------------------------------------------------------------------
4269: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4270:
4271: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4272: IF (g_debug_mode = 'Y') THEN
4273: g_debug_msg := ' Beginning Inserting Archive History Records for Last Activity Date : ' ||
4274: g_last_activity_date;
4275: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4293: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4289: IF (c_get_archived_hdrs%FOUND) THEN
4290:
4291: WHILE (c_get_archived_hdrs%FOUND) LOOP
4292:
4293: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4294: IF (g_debug_mode = 'Y') THEN
4295: g_debug_msg := ' Inserting Archive History Record for CC Header ID : ' ||
4296: l_cc_header_id;
4297: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4383: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

4379: l_cc_header_id || ' But could not find it in Cursor.';
4380: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4381: END IF;
4382:
4383: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4384: p_tokval => g_sob_id);
4385: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4386: p_tokval => g_cc_num);
4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 4385: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

4381: END IF;
4382:
4383: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4384: p_tokval => g_sob_id);
4385: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4386: p_tokval => g_cc_num);
4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4388: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4389: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

4383: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4384: p_tokval => g_sob_id);
4385: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4386: p_tokval => g_cc_num);
4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4388: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4389: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4390: p_tokval => 'CC');
4391: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 4389: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

4385: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4386: p_tokval => g_cc_num);
4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4388: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4389: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4390: p_tokval => 'CC');
4391: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4392: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
4393: raise FND_API.G_EXC_ERROR;

Line 4391: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

4387: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4388: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4389: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4390: p_tokval => 'CC');
4391: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4392: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
4393: raise FND_API.G_EXC_ERROR;
4394:
4395: END IF;

Line 4415: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

4411: g_debug_msg := 'No Archive Candidates to insert into history table.';
4412: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4413: END IF;
4414:
4415: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4416: p_tokval => g_sob_id);
4417: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4418: p_tokval => g_cc_num);
4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 4417: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

4413: END IF;
4414:
4415: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4416: p_tokval => g_sob_id);
4417: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4418: p_tokval => g_cc_num);
4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4420: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4421: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

4415: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
4416: p_tokval => g_sob_id);
4417: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4418: p_tokval => g_cc_num);
4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4420: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4421: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4422: p_tokval => 'CC');
4423: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 4421: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

4417: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
4418: p_tokval => g_cc_num);
4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4420: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4421: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4422: p_tokval => 'CC');
4423: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4424: p_msgname => 'IGC_NO_ARC_RECORDS');
4425:

Line 4423: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

4419: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
4420: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
4421: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
4422: p_tokval => 'CC');
4423: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4424: p_msgname => 'IGC_NO_ARC_RECORDS');
4425:
4426: END IF;
4427:

Line 4554: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4550:
4551: IF (c_lock_candidates%NOTFOUND) THEN
4552:
4553: CLOSE c_lock_candidates;
4554: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4555: IF (g_debug_mode = 'Y') THEN
4556: Output_Debug (l_full_path, 'No records found to lock in IGC_CC_ARC_PUR_CANDIDATES');
4557: END IF;
4558: RETURN TRUE;

Line 4582: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',

4578: IF (SQLCODE = -54) THEN -- Record(s) are already locked
4579: l_counter := l_counter + 1;
4580:
4581: IF (l_counter >= g_maxloops) THEN -- Tried max number of times
4582: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
4583: p_tokval => to_char(g_maxloops));
4584: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4585: p_msgname => 'IGC_CC_UNABLE_TO_LOCK');
4586:

Line 4584: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

4580:
4581: IF (l_counter >= g_maxloops) THEN -- Tried max number of times
4582: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
4583: p_tokval => to_char(g_maxloops));
4584: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
4585: p_msgname => 'IGC_CC_UNABLE_TO_LOCK');
4586:
4587: IF (c_lock_candidates%ISOPEN) THEN
4588: CLOSE c_lock_candidates;

Line 4590: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4586:
4587: IF (c_lock_candidates%ISOPEN) THEN
4588: CLOSE c_lock_candidates;
4589: END IF;
4590: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4591: IF (g_debug_mode = 'Y') THEN
4592: Output_Debug (l_full_path, 'Maximum tries reached: unable to lock IGC_CC_ARC_PUR_CANDIDATES');
4593: END IF;
4594: RETURN FALSE;

Line 4661: /* IGC_MSGS_PKG.Put_Debug_Msg (p_debug_message => p_debug_msg,

4657: l_api_name CONSTANT VARCHAR2(30) := 'Output_Debug';
4658:
4659: BEGIN
4660:
4661: /* IGC_MSGS_PKG.Put_Debug_Msg (p_debug_message => p_debug_msg,
4662: p_profile_log_name => l_profile_name,
4663: p_prod => l_prod,
4664: p_sub_comp => l_sub_comp,
4665: p_filename_val => NULL,

Line 4723: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4719: -- Initialize Return status and other local variables.
4720: -- --------------------------------------------------------------------
4721: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4722:
4723: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4724: IF (g_debug_mode = 'Y') THEN
4725: g_debug_msg := ' Beginning Purge process for Last Activity Date : ' ||
4726: g_last_activity_date;
4727: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4738: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4734: -- were previously archived.
4735: -- -------------------------------------------------------------------
4736: IF (g_mrc_installed = 'Y') THEN
4737:
4738: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4739: IF (g_debug_mode = 'Y') THEN
4740: g_debug_msg := ' Attempt delete records in MRC tables. Last Activity Date : ' ||
4741: g_last_activity_date;
4742: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4753: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4749: END IF;
4750:
4751: ELSE
4752:
4753: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4754: IF (g_debug_mode = 'Y') THEN
4755: g_debug_msg := ' NOT deleting records from MRC tables. Last Activity Date : ' ||
4756: g_last_activity_date;
4757: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4764: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4760: END IF;
4761:
4762: END IF;
4763:
4764: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4765: IF (g_debug_mode = 'Y') THEN
4766: g_debug_msg := ' Attempt delete records in NON MRC tables. Last Activity Date : ' ||
4767: g_last_activity_date;
4768: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 4859: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

4855: -- Initialize Return status and other local variables.
4856: -- --------------------------------------------------------------------
4857: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4858:
4859: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
4860: IF (g_debug_mode = 'Y') THEN
4861: g_debug_msg := ' Beginning Purge MRC Tables process for Last Activity Date : ' ||
4862: g_last_activity_date;
4863: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 5066: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',

5062: '. Thus no Purge can be done for Header ID.';
5063: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5064: END IF;
5065:
5066: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5067: p_tokval => g_cc_num);
5068: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5069: p_tokval => g_sob_id);
5070: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5068: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5064: END IF;
5065:
5066: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5067: p_tokval => g_cc_num);
5068: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5069: p_tokval => g_sob_id);
5070: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5071: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5072: raise FND_API.G_EXC_ERROR;

Line 5070: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5066: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5067: p_tokval => g_cc_num);
5068: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5069: p_tokval => g_sob_id);
5070: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5071: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5072: raise FND_API.G_EXC_ERROR;
5073:
5074: END IF;

Line 5085: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',

5081: '. Thus no Purge can be done for Header ID.';
5082: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5083: END IF;
5084:
5085: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5086: p_tokval => g_cc_num);
5087: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5088: p_tokval => g_sob_id);
5089: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5087: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5083: END IF;
5084:
5085: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5086: p_tokval => g_cc_num);
5087: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5088: p_tokval => g_sob_id);
5089: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5090: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5091: raise FND_API.G_EXC_ERROR;

Line 5089: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5085: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5086: p_tokval => g_cc_num);
5087: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5088: p_tokval => g_sob_id);
5089: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5090: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5091: raise FND_API.G_EXC_ERROR;
5092:
5093: END IF;

Line 5115: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',

5111: l_cc_header_id || ' But could not find it in Cursor.';
5112: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5113: END IF;
5114:
5115: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5116: p_tokval => g_cc_num);
5117: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5118: p_tokval => g_sob_id);
5119: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5117: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5113: END IF;
5114:
5115: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5116: p_tokval => g_cc_num);
5117: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5118: p_tokval => g_sob_id);
5119: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5120: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5121: raise FND_API.G_EXC_ERROR;

Line 5119: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5115: IGC_MSGS_PKG.message_token (p_tokname => 'CC_NUM',
5116: p_tokval => g_cc_num);
5117: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5118: p_tokval => g_sob_id);
5119: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5120: p_msgname => 'IGC_NUM_MC_PUR_NO_MATCH_ARC');
5121: raise FND_API.G_EXC_ERROR;
5122:
5123: END IF;

Line 5228: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5224: -- Initialize Return status and other local variables.
5225: -- --------------------------------------------------------------------
5226: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
5227:
5228: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5229: IF (g_debug_mode = 'Y') THEN
5230: g_debug_msg := ' Beginning Purge NON MRC Tables process for Last Activity Date : ' ||
5231: g_last_activity_date;
5232: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 5506: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5502: '. Thus no Purge can be done for Header ID.';
5503: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5504: END IF;
5505:
5506: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5507: p_tokval => g_sob_id);
5508: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5509: p_tokval => l_cc_header_id);
5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 5508: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

5504: END IF;
5505:
5506: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5507: p_tokval => g_sob_id);
5508: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5509: p_tokval => l_cc_header_id);
5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5511: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5512: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

5506: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5507: p_tokval => g_sob_id);
5508: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5509: p_tokval => l_cc_header_id);
5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5511: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5512: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5513: p_tokval => 'CC');
5514: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5512: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5508: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5509: p_tokval => l_cc_header_id);
5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5511: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5512: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5513: p_tokval => 'CC');
5514: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5515: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5516: raise FND_API.G_EXC_ERROR;

Line 5514: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5510: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5511: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5512: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5513: p_tokval => 'CC');
5514: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5515: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5516: raise FND_API.G_EXC_ERROR;
5517:
5518: END IF;

Line 5561: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5557: '. Thus no Purge can be done for Header ID.';
5558: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5559: END IF;
5560:
5561: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5562: p_tokval => g_sob_id);
5563: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5564: p_tokval => l_cc_header_id);
5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 5563: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

5559: END IF;
5560:
5561: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5562: p_tokval => g_sob_id);
5563: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5564: p_tokval => l_cc_header_id);
5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5566: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5567: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

5561: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5562: p_tokval => g_sob_id);
5563: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5564: p_tokval => l_cc_header_id);
5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5566: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5567: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5568: p_tokval => 'CC');
5569: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5567: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5563: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5564: p_tokval => l_cc_header_id);
5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5566: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5567: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5568: p_tokval => 'CC');
5569: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5570: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5571: raise FND_API.G_EXC_ERROR;

Line 5569: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5565: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5566: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5567: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5568: p_tokval => 'CC');
5569: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5570: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5571: raise FND_API.G_EXC_ERROR;
5572:
5573: END IF;

Line 5595: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5591: l_cc_header_id || ' But could not find it in Cursor.';
5592: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5593: END IF;
5594:
5595: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5596: p_tokval => g_sob_id);
5597: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5598: p_tokval => l_cc_header_id);
5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

Line 5597: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',

5593: END IF;
5594:
5595: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5596: p_tokval => g_sob_id);
5597: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5598: p_tokval => l_cc_header_id);
5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5600: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5601: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',

5595: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5596: p_tokval => g_sob_id);
5597: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5598: p_tokval => l_cc_header_id);
5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5600: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5601: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5602: p_tokval => 'CC');
5603: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5601: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5597: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE1',
5598: p_tokval => l_cc_header_id);
5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5600: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5601: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5602: p_tokval => 'CC');
5603: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5604: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5605: raise FND_API.G_EXC_ERROR;

Line 5603: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5599: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE2',
5600: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5601: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5602: p_tokval => 'CC');
5603: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5604: p_msgname => 'IGC_NUM_PUR_NO_MATCH_ARC');
5605: raise FND_API.G_EXC_ERROR;
5606:
5607: END IF;

Line 5703: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5699: -- Initialize Return status and other local variables.
5700: -- --------------------------------------------------------------------
5701: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
5702:
5703: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5704: IF (g_debug_mode = 'Y') THEN
5705: g_debug_msg := ' Calling Update History for CC Header ID : ' ||
5706: p_History_Rec.cc_header_id;
5707: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 5725: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5721: -- If the record is not found then insert new record into the table.
5722: -- --------------------------------------------------------------------
5723: IF (c_archive_history%NOTFOUND) THEN
5724:
5725: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5726: IF (g_debug_mode = 'Y') THEN
5727: g_debug_msg := ' Inserting Archive History Record for CC Header ID : ' ||
5728: p_History_Rec.cc_header_id ||
5729: ' Set Of Books ID : ' || p_History_Rec.set_of_books_id;

Line 5786: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5782: p_History_Rec.creation_date
5783: );
5784:
5785: IF (SQL%ROWCOUNT <> 1) THEN
5786: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5787: p_tokval => p_History_Rec.set_of_books_id);
5788: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5789: p_tokval => p_History_Rec.cc_num);
5790: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5788: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',

5784:
5785: IF (SQL%ROWCOUNT <> 1) THEN
5786: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5787: p_tokval => p_History_Rec.set_of_books_id);
5788: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5789: p_tokval => p_History_Rec.cc_num);
5790: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5791: p_tokval => 'CC');
5792: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5790: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5786: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5787: p_tokval => p_History_Rec.set_of_books_id);
5788: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5789: p_tokval => p_History_Rec.cc_num);
5790: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5791: p_tokval => 'CC');
5792: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5793: p_msgname => 'IGC_INSERT_ARC_PUR_HISTORY');
5794: raise FND_API.G_EXC_ERROR;

Line 5792: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5788: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5789: p_tokval => p_History_Rec.cc_num);
5790: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5791: p_tokval => 'CC');
5792: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5793: p_msgname => 'IGC_INSERT_ARC_PUR_HISTORY');
5794: raise FND_API.G_EXC_ERROR;
5795: END IF;
5796:

Line 5799: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5795: END IF;
5796:
5797: ELSE -- Update existing record
5798:
5799: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5800: IF (g_debug_mode = 'Y') THEN
5801: g_debug_msg := ' Updating Archive History Record for CC Header ID : ' ||
5802: p_History_Rec.cc_header_id ||
5803: ' Set Of Books ID : ' || p_History_Rec.set_of_books_id;

Line 5832: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5828: AND cc_num = p_History_Rec.cc_num
5829: AND cc_type = p_History_Rec.cc_type;
5830:
5831: IF (SQL%ROWCOUNT <> 1) THEN
5832: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5833: p_tokval => p_History_Rec.set_of_books_id);
5834: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5835: p_tokval => p_History_Rec.cc_num);
5836: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5834: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',

5830:
5831: IF (SQL%ROWCOUNT <> 1) THEN
5832: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5833: p_tokval => p_History_Rec.set_of_books_id);
5834: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5835: p_tokval => p_History_Rec.cc_num);
5836: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5837: p_tokval => 'CC');
5838: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5836: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5832: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5833: p_tokval => p_History_Rec.set_of_books_id);
5834: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5835: p_tokval => p_History_Rec.cc_num);
5836: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5837: p_tokval => 'CC');
5838: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5839: p_msgname => 'IGC_UPDATE_ARC_PUR_HISTORY');
5840: raise FND_API.G_EXC_ERROR;

Line 5838: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5834: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5835: p_tokval => p_History_Rec.cc_num);
5836: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5837: p_tokval => 'CC');
5838: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5839: p_msgname => 'IGC_UPDATE_ARC_PUR_HISTORY');
5840: raise FND_API.G_EXC_ERROR;
5841: END IF;
5842:

Line 5940: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5936: -- Make sure that the input mode of the process is a valid input. The
5937: -- set of values allowed are 'A' Archive or 'P' Purge.
5938: -- --------------------------------------------------------------------
5939: IF (g_mode NOT IN ('AR', 'PP', 'PU')) THEN
5940: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5941: IF (g_debug_mode = 'Y') THEN
5942: g_debug_msg := ' Invalid Archive / Purge mode passed in : ' || g_mode ||
5943: ' Exiting process.';
5944: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 5946: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5942: g_debug_msg := ' Invalid Archive / Purge mode passed in : ' || g_mode ||
5943: ' Exiting process.';
5944: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5945: END IF;
5946: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5947: p_tokval => g_sob_id);
5948: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5949: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',

Line 5948: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',

5944: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5945: END IF;
5946: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5947: p_tokval => g_sob_id);
5948: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5949: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',
5951: p_tokval => g_mode);
5952: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

Line 5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',

5946: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5947: p_tokval => g_sob_id);
5948: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5949: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',
5951: p_tokval => g_mode);
5952: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5953: p_tokval => 'CC');
5954: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5952: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',

5948: IGC_MSGS_PKG.message_token (p_tokname => 'VALUE',
5949: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',
5951: p_tokval => g_mode);
5952: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5953: p_tokval => 'CC');
5954: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5955: p_msgname => 'IGC_INVALID_ARC_PUR_MODE');
5956: raise FND_API.G_EXC_ERROR;

Line 5954: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5950: IGC_MSGS_PKG.message_token (p_tokname => 'MODE',
5951: p_tokval => g_mode);
5952: IGC_MSGS_PKG.message_token (p_tokname => 'COMPONENT',
5953: p_tokval => 'CC');
5954: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5955: p_msgname => 'IGC_INVALID_ARC_PUR_MODE');
5956: raise FND_API.G_EXC_ERROR;
5957: END IF;
5958:

Line 5965: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5961: -- records present for the SOB and the ORG ID given.
5962: -- --------------------------------------------------------------------
5963: IF g_sob_id is NULL THEN
5964:
5965: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5966: IF (g_debug_mode = 'Y') THEN
5967: g_debug_msg := ' Set of books ID is NULL. Exiting.';
5968: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5969: END IF;

Line 5971: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5967: g_debug_msg := ' Set of books ID is NULL. Exiting.';
5968: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5969: END IF;
5970:
5971: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5972: p_tokval => 'NULL');
5973: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5974: p_msgname => 'IGC_INVALID_SOB_ARCHIVE');
5975: g_validation_error := TRUE;

Line 5973: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5969: END IF;
5970:
5971: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5972: p_tokval => 'NULL');
5973: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
5974: p_msgname => 'IGC_INVALID_SOB_ARCHIVE');
5975: g_validation_error := TRUE;
5976:
5977: ELSE

Line 5989: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

5985: INTO l_cc_header_id;
5986:
5987: IF (c_validate_sob_org%NOTFOUND) THEN
5988:
5989: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
5990: IF (g_debug_mode = 'Y') THEN
5991: g_debug_msg := ' Set of books ID : ' || g_sob_id ||
5992: ' and ORG ID : ' || g_org_id ||
5993: ' Combination not found in IGC_CC_HEADERS. Exiting.';

Line 5997: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

5993: ' Combination not found in IGC_CC_HEADERS. Exiting.';
5994: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5995: END IF;
5996:
5997: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5998: p_tokval => g_sob_id);
5999: IGC_MSGS_PKG.message_token (p_tokname => 'ORG_ID',
6000: p_tokval => g_org_id);
6001: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 5999: IGC_MSGS_PKG.message_token (p_tokname => 'ORG_ID',

5995: END IF;
5996:
5997: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5998: p_tokval => g_sob_id);
5999: IGC_MSGS_PKG.message_token (p_tokname => 'ORG_ID',
6000: p_tokval => g_org_id);
6001: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
6002: p_msgname => 'IGC_NO_SOB_ORG_COMBO');
6003: g_validation_error := TRUE;

Line 6001: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

5997: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
5998: p_tokval => g_sob_id);
5999: IGC_MSGS_PKG.message_token (p_tokname => 'ORG_ID',
6000: p_tokval => g_org_id);
6001: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
6002: p_msgname => 'IGC_NO_SOB_ORG_COMBO');
6003: g_validation_error := TRUE;
6004: END IF;
6005:

Line 6020: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN

6016: -- purging.
6017: -- --------------------------------------------------------------------
6018: IF (sign(sysdate - nvl(g_last_activity_date, sysdate)) < 0) THEN
6019:
6020: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
6021: IF (g_debug_mode = 'Y') THEN
6022: g_debug_msg := ' Last Activity date is not valid. Future Date : ' ||
6023: g_last_activity_date;
6024: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);

Line 6027: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',

6023: g_last_activity_date;
6024: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
6025: END IF;
6026:
6027: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
6028: p_tokval => g_sob_id);
6029: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
6030: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
6031: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

Line 6029: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',

6025: END IF;
6026:
6027: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
6028: p_tokval => g_sob_id);
6029: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
6030: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
6031: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
6032: p_msgname => 'IGC_INVALID_DATE_INPUT');
6033: g_validation_error := TRUE;

Line 6031: IGC_MSGS_PKG.add_message (p_appname => 'IGC',

6027: IGC_MSGS_PKG.message_token (p_tokname => 'SOB_ID',
6028: p_tokval => g_sob_id);
6029: IGC_MSGS_PKG.message_token (p_tokname => 'INPUT_DATE',
6030: p_tokval => FND_DATE.DATE_TO_CHARDATE (g_last_activity_date));
6031: IGC_MSGS_PKG.add_message (p_appname => 'IGC',
6032: p_msgname => 'IGC_INVALID_DATE_INPUT');
6033: g_validation_error := TRUE;
6034: END IF;
6035: