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.IGS_CA_INS_ROLL_CI dependencies on IGS_GE_DATE

Line 291: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||

287:
288: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
289: '|' || p_dai_sequence_number||'|' ;
290:
291: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);

288: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
289: '|' || p_dai_sequence_number||'|' ;
290:
291: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
296: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 326: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||

322:
323: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
324: '|' || p_dai_sequence_number||'|' ;
325:
326: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);

323: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
324: '|' || p_dai_sequence_number||'|' ;
325:
326: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
331: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 363: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

359: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
360: '|' || p_dai_sequence_number||'|';
361:
362: token2_val := p_val_dt_alias||'('||p_val_dai_sequence_number||')'||
363: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
364: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
365:
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');

Line 364: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);

360: '|' || p_dai_sequence_number||'|';
361:
362: token2_val := p_val_dt_alias||'('||p_val_dai_sequence_number||')'||
363: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
364: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
365:
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
368: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 399: token2_val := p_val_dt_alias||' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

395:
396: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
397: '|' || p_dai_sequence_number||'|' ;
398:
399: token2_val := p_val_dt_alias||' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
403: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';

396: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
397: '|' || p_dai_sequence_number||'|' ;
398:
399: token2_val := p_val_dt_alias||' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
403: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
404: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 475: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

471: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
472: '|' || p_val_dai_sequence_number||'|';
473:
474: token2_val := p_dt_alias||'('||p_dai_sequence_number||')'||
475: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
476: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
477:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');

Line 476: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);

472: '|' || p_val_dai_sequence_number||'|';
473:
474: token2_val := p_dt_alias||'('||p_dai_sequence_number||')'||
475: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
476: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
477:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
480: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 507: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||

503:
504: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
505: '|' || p_val_dai_sequence_number||'|' ;
506:
507: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);

504: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
505: '|' || p_val_dai_sequence_number||'|' ;
506:
507: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
512: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 900: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

896:
897: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
898: '|' || p_dai_sequence_number||'|';
899:
900: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
901: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
902:
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');

Line 901: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);

897: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
898: '|' || p_dai_sequence_number||'|';
899:
900: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
901: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
902:
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 936: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||

932:
933: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
934: '|' || p_dai_sequence_number||'|' ;
935:
936: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);

933: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
934: '|' || p_dai_sequence_number||'|' ;
935:
936: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
941: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 971: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

967: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
968: '|' || p_dai_sequence_number||'|';
969:
970: token2_val := p_val_dt_alias||'('||p_val_dai_sequence_number||')'||
971: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
972: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
973:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');

Line 972: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);

968: '|' || p_dai_sequence_number||'|';
969:
970: token2_val := p_val_dt_alias||'('||p_val_dai_sequence_number||')'||
971: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
972: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
973:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
976: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1006: ' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

1002: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
1003: '|' || p_dai_sequence_number||'|' ;
1004:
1005: token2_val := p_val_dt_alias||' '||p_val_cal_type||
1006: ' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
1010: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';

1003: '|' || p_dai_sequence_number||'|' ;
1004:
1005: token2_val := p_val_dt_alias||' '||p_val_cal_type||
1006: ' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
1010: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1011: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1132: ' '||p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||

1128: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
1129: '|' || p_val_dai_sequence_number||'|';
1130:
1131: token2_val := p_dt_alias||'('||p_dai_sequence_number||')'||
1132: ' '||p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
1136: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);

1129: '|' || p_val_dai_sequence_number||'|';
1130:
1131: token2_val := p_dt_alias||'('||p_dai_sequence_number||')'||
1132: ' '||p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
1136: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1137: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1163: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||

1159:
1160: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
1161: '|' || p_dai_sequence_number||'|';
1162:
1163: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
1164: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
1165:
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');

Line 1164: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);

1160: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_dt_alias||
1161: '|' || p_dai_sequence_number||'|';
1162:
1163: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
1164: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
1165:
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1752: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||

1748: IF v_derived_cal_instance_rec.s_cal_status = cst_inactive THEN
1749: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1750: -- for reporting purposes
1751: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1752: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1753: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1754:
1755: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INACTIVE');
1756: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1753: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

1749: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1750: -- for reporting purposes
1751: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1752: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1753: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1754:
1755: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INACTIVE');
1756: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1757: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1786: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||

1782: p_message_name) THEN
1783: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY for reporting purposes
1784:
1785: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1786: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1787: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1790: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1787: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

1783: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY for reporting purposes
1784:
1785: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1786: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1787: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1790: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1791: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1874: token2_val := v_cal_inst_rec.CAL_TYPE||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||

1870: -- for reporting purposes when superior calendar instance does
1871: -- not exist.
1872:
1873: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1874: token2_val := v_cal_inst_rec.CAL_TYPE||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

1871: -- not exist.
1872:
1873: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1874: token2_val := v_cal_inst_rec.CAL_TYPE||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1879: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1931: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||

1927: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1928: -- for reporting purposes
1929:
1930: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1931: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1933:
1934: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1935: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

1928: -- for reporting purposes
1929:
1930: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1931: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1933:
1934: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1935: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1936: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 1969: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.start_dt) ||

1965:
1966: -- Remove calendar instance not exists exception reporting if it exists
1967:
1968: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1969: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.start_dt) ||
1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);

1966: -- Remove calendar instance not exists exception reporting if it exists
1967:
1968: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1969: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.start_dt) ||
1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1974: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||

2218:
2219: ELSIF(v_message_name = 'IGS_OR_ADDR_TYPE_CLOSE') THEN
2220:
2221: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;

2219: ELSIF(v_message_name = 'IGS_OR_ADDR_TYPE_CLOSE') THEN
2220:
2221: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2227: v_other_detail:=FND_MESSAGE.GET;

Line 2256: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||

2252: p_message_name) = TRUE) THEN
2253: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting
2254: -- why the calendar instance was not rolled.
2255: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2256: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
2260: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;

2253: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting
2254: -- why the calendar instance was not rolled.
2255: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2256: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
2260: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2261: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 2310: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||

2306: -- why the calendar instance was not rolled.
2307:
2308:
2309: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2310: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
2314: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);

Line 2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);

2307:
2308:
2309: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2310: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
2314: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2315: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);

Line 2396: -- IGS_GE_DATE.IGSCHAR(v_new_start_dt),8,4 to IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4

2392:
2393: --
2394: -- Bug ID 1951883 // IGSCA002: ROLLING OVER CALENDAR PRODUCES INCORRECT ALTERNATE CODE
2395: -- Modified the substr parameter from
2396: -- IGS_GE_DATE.IGSCHAR(v_new_start_dt),8,4 to IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4
2397: --
2398: v_new_alternate_code :=
2399: substr(IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4);
2400: -- added for bug 2563531

Line 2399: substr(IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4);

2395: -- Modified the substr parameter from
2396: -- IGS_GE_DATE.IGSCHAR(v_new_start_dt),8,4 to IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4
2397: --
2398: v_new_alternate_code :=
2399: substr(IGS_GE_DATE.IGSCHAR(v_new_start_dt),1,4);
2400: -- added for bug 2563531
2401: OPEN alt_code_unique(v_new_alternate_code);
2402: FETCH alt_code_unique INTO l_count;
2403: IF l_count > 0 THEN