DBA Data[Home] [Help]

APPS.AP_IAW_PKG dependencies on FND_MESSAGE

Line 73: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

69: EXCEPTION
70: WHEN OTHERS THEN
71:
72: IF (SQLCODE <> -20001) THEN
73: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
74: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
75: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'get_max_notif_iteration');
76: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
77: END IF;

Line 74: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

70: WHEN OTHERS THEN
71:
72: IF (SQLCODE <> -20001) THEN
73: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
74: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
75: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'get_max_notif_iteration');
76: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
77: END IF;
78: APP_EXCEPTION.RAISE_EXCEPTION;

Line 75: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'get_max_notif_iteration');

71:
72: IF (SQLCODE <> -20001) THEN
73: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
74: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
75: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'get_max_notif_iteration');
76: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
77: END IF;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79:

Line 76: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

72: IF (SQLCODE <> -20001) THEN
73: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
74: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
75: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'get_max_notif_iteration');
76: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
77: END IF;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79:
80: END get_max_notif_iteration;

Line 1308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1304: EXCEPTION
1305: WHEN OTHERS
1306: THEN
1307: IF (SQLCODE <> -20001) THEN
1308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
1311: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1312: END IF;

Line 1309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1305: WHEN OTHERS
1306: THEN
1307: IF (SQLCODE <> -20001) THEN
1308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
1311: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1312: END IF;
1313: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

1306: THEN
1307: IF (SQLCODE <> -20001) THEN
1308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
1311: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1312: END IF;
1313: APP_EXCEPTION.RAISE_EXCEPTION;
1314:

Line 1311: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

1307: IF (SQLCODE <> -20001) THEN
1308: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1310: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
1311: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
1312: END IF;
1313: APP_EXCEPTION.RAISE_EXCEPTION;
1314:
1315: END Get_All_Approvers;

Line 2021: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2017: EXCEPTION
2018: WHEN OTHERS THEN
2019:
2020: IF (SQLCODE <> -20001) THEN
2021: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2022: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2023: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2024: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2025: END IF;

Line 2022: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2018: WHEN OTHERS THEN
2019:
2020: IF (SQLCODE <> -20001) THEN
2021: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2022: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2023: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2024: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2025: END IF;
2026: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2023: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

2019:
2020: IF (SQLCODE <> -20001) THEN
2021: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2022: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2023: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2024: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2025: END IF;
2026: APP_EXCEPTION.RAISE_EXCEPTION;
2027:

Line 2024: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

2020: IF (SQLCODE <> -20001) THEN
2021: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2022: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2023: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2024: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2025: END IF;
2026: APP_EXCEPTION.RAISE_EXCEPTION;
2027:
2028: END IAW_Raise_Event;

Line 2912: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2908: EXCEPTION
2909: WHEN OTHERS THEN
2910:
2911: IF (SQLCODE <> -20001) THEN
2912: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2913: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2914: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2916: END IF;

Line 2913: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2909: WHEN OTHERS THEN
2910:
2911: IF (SQLCODE <> -20001) THEN
2912: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2913: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2914: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2916: END IF;
2917: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2914: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

2910:
2911: IF (SQLCODE <> -20001) THEN
2912: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2913: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2914: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2916: END IF;
2917: APP_EXCEPTION.RAISE_EXCEPTION;
2918: END Clear_AME_History_Header;

Line 2915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

2911: IF (SQLCODE <> -20001) THEN
2912: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2913: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2914: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2916: END IF;
2917: APP_EXCEPTION.RAISE_EXCEPTION;
2918: END Clear_AME_History_Header;
2919:

Line 2973: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2969: EXCEPTION
2970: WHEN OTHERS THEN
2971:
2972: IF (SQLCODE <> -20001) THEN
2973: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2974: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2975: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2976: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2977: END IF;

Line 2974: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2970: WHEN OTHERS THEN
2971:
2972: IF (SQLCODE <> -20001) THEN
2973: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2974: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2975: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2976: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2977: END IF;
2978: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2975: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

2971:
2972: IF (SQLCODE <> -20001) THEN
2973: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2974: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2975: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2976: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2977: END IF;
2978: APP_EXCEPTION.RAISE_EXCEPTION;
2979:

Line 2976: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

2972: IF (SQLCODE <> -20001) THEN
2973: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2974: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2975: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
2976: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2977: END IF;
2978: APP_EXCEPTION.RAISE_EXCEPTION;
2979:
2980: END Clear_AME_History_Line;

Line 3144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3140: EXCEPTION
3141: WHEN OTHERS THEN
3142:
3143: IF (SQLCODE <> -20001) THEN
3144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3147: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3148: END IF;

Line 3145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3141: WHEN OTHERS THEN
3142:
3143: IF (SQLCODE <> -20001) THEN
3144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3147: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3148: END IF;
3149: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

3142:
3143: IF (SQLCODE <> -20001) THEN
3144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3147: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3148: END IF;
3149: APP_EXCEPTION.RAISE_EXCEPTION;
3150:

Line 3147: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

3143: IF (SQLCODE <> -20001) THEN
3144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3147: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3148: END IF;
3149: APP_EXCEPTION.RAISE_EXCEPTION;
3150:
3151: END Stop_Approval;

Line 3244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3240: EXCEPTION
3241: WHEN OTHERS THEN
3242:
3243: IF (SQLCODE <> -20001) THEN
3244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3247: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3248: END IF;

Line 3245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3241: WHEN OTHERS THEN
3242:
3243: IF (SQLCODE <> -20001) THEN
3244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3247: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3248: END IF;
3249: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

3242:
3243: IF (SQLCODE <> -20001) THEN
3244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3247: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3248: END IF;
3249: APP_EXCEPTION.RAISE_EXCEPTION;
3250:

Line 3247: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

3243: IF (SQLCODE <> -20001) THEN
3244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3247: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3248: END IF;
3249: APP_EXCEPTION.RAISE_EXCEPTION;
3250:
3251: END Terminate_Approval;

Line 3292: l_reason_flex := FND_MESSAGE.GET;

3288: 'SQLGL',
3289: 'GL#',
3290: l_chart_of_accounts_id);
3291: IF (NOT l_result) THEN
3292: l_reason_flex := FND_MESSAGE.GET;
3293: END IF;
3294:
3295: l_result := FND_FLEX_EXT.GET_SEGMENTS(
3296: 'SQLGL',

Line 3304: l_reason_flex := FND_MESSAGE.GET;

3300: l_num_segments,
3301: l_segments);
3302:
3303: IF (NOT l_result) THEN
3304: l_reason_flex := FND_MESSAGE.GET;
3305: END IF;
3306:
3307: l_result := FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
3308: 101,

Line 3314: l_reason_flex := FND_MESSAGE.GET;

3310: l_chart_of_accounts_id,
3311: p_seg_name,
3312: l_segment_num);
3313: IF (NOT l_result) THEN
3314: l_reason_flex := FND_MESSAGE.GET;
3315: END IF;
3316:
3317: l_seg_val := l_segments(l_segment_num);
3318:

Line 3952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3948: EXCEPTION
3949: WHEN OTHERS THEN
3950:
3951: IF (SQLCODE <> -20001) THEN
3952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3954: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3956: END IF;

Line 3953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3949: WHEN OTHERS THEN
3950:
3951: IF (SQLCODE <> -20001) THEN
3952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3954: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3956: END IF;
3957: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3954: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

3950:
3951: IF (SQLCODE <> -20001) THEN
3952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3954: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3956: END IF;
3957: APP_EXCEPTION.RAISE_EXCEPTION;
3958:

Line 3955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

3951: IF (SQLCODE <> -20001) THEN
3952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3954: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
3955: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
3956: END IF;
3957: APP_EXCEPTION.RAISE_EXCEPTION;
3958:
3959: end insert_approver_rec;

Line 4270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

4266: WHEN OTHERS THEN
4267: -- TODO: close all cursors
4268:
4269: IF (SQLCODE <> -20001) THEN
4270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4272: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
4273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4274: END IF;

Line 4271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

4267: -- TODO: close all cursors
4268:
4269: IF (SQLCODE <> -20001) THEN
4270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4272: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
4273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4274: END IF;
4275: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4272: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

4268:
4269: IF (SQLCODE <> -20001) THEN
4270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4272: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
4273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4274: END IF;
4275: APP_EXCEPTION.RAISE_EXCEPTION;
4276:

Line 4273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

4269: IF (SQLCODE <> -20001) THEN
4270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4272: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
4273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4274: END IF;
4275: APP_EXCEPTION.RAISE_EXCEPTION;
4276:
4277: end assign_internal_rep;