DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on FND_MESSAGE

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

1008:
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF (SQLCODE <> -20001) THEN
1012: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1013: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1014: END IF;
1015: APP_EXCEPTION.RAISE_EXCEPTION;
1016:

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

1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF (SQLCODE <> -20001) THEN
1012: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1013: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1014: END IF;
1015: APP_EXCEPTION.RAISE_EXCEPTION;
1016:
1017: END Print;

Line 2644: fnd_message.set_encoded(l_errmsg);

2640: -- Show error message
2641:
2642: -- CHANGES FOR BUG - 3657665 ** STARTS **
2643: -- Need to encode the message and then print the value for the same returned by PA.
2644: fnd_message.set_encoded(l_errmsg);
2645: l_errmsg := fnd_message.get;
2646: -- CHANGES FOR BUG - 3657665 ** ENDS **
2647:
2648: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 2645: l_errmsg := fnd_message.get;

2641:
2642: -- CHANGES FOR BUG - 3657665 ** STARTS **
2643: -- Need to encode the message and then print the value for the same returned by PA.
2644: fnd_message.set_encoded(l_errmsg);
2645: l_errmsg := fnd_message.get;
2646: -- CHANGES FOR BUG - 3657665 ** ENDS **
2647:
2648: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2649: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

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

4975:
4976: EXCEPTION
4977: WHEN OTHERS then
4978: IF (SQLCODE <> -20001) THEN
4979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4983: ' Application Id = ' || to_char(P_Application_Id) );

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

4976: EXCEPTION
4977: WHEN OTHERS then
4978: IF (SQLCODE <> -20001) THEN
4979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4983: ' Application Id = ' || to_char(P_Application_Id) );
4984: END IF;

Line 4981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

4977: WHEN OTHERS then
4978: IF (SQLCODE <> -20001) THEN
4979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4983: ' Application Id = ' || to_char(P_Application_Id) );
4984: END IF;
4985: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4982: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4978: IF (SQLCODE <> -20001) THEN
4979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4983: ' Application Id = ' || to_char(P_Application_Id) );
4984: END IF;
4985: APP_EXCEPTION.RAISE_EXCEPTION;
4986:

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

5042:
5043: EXCEPTION
5044: WHEN OTHERS then
5045: IF (SQLCODE <> -20001) THEN
5046: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5047: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5048: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5049: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5050: END IF;

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

5043: EXCEPTION
5044: WHEN OTHERS then
5045: IF (SQLCODE <> -20001) THEN
5046: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5047: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5048: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5049: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5050: END IF;
5051: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5048: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

5044: WHEN OTHERS then
5045: IF (SQLCODE <> -20001) THEN
5046: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5047: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5048: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5049: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5050: END IF;
5051: APP_EXCEPTION.RAISE_EXCEPTION;
5052:

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

5045: IF (SQLCODE <> -20001) THEN
5046: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5047: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5048: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5049: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5050: END IF;
5051: APP_EXCEPTION.RAISE_EXCEPTION;
5052:
5053: END Cache_Org_Id_Name;

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

5150:
5151: EXCEPTION
5152: WHEN OTHERS THEN
5153: IF (SQLCODE <> -20001) THEN
5154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5158: 'Payment Terms = '|| p_terms_id

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

5151: EXCEPTION
5152: WHEN OTHERS THEN
5153: IF (SQLCODE <> -20001) THEN
5154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5158: 'Payment Terms = '|| p_terms_id
5159: ||' Terms date = '||to_char(p_terms_date));

Line 5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

5152: WHEN OTHERS THEN
5153: IF (SQLCODE <> -20001) THEN
5154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5158: 'Payment Terms = '|| p_terms_id
5159: ||' Terms date = '||to_char(p_terms_date));
5160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',

5153: IF (SQLCODE <> -20001) THEN
5154: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5155: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5158: 'Payment Terms = '|| p_terms_id
5159: ||' Terms date = '||to_char(p_terms_date));
5160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5161: END IF;

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

5156: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5157: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5158: 'Payment Terms = '|| p_terms_id
5159: ||' Terms date = '||to_char(p_terms_date));
5160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5161: END IF;
5162: APP_EXCEPTION.RAISE_EXCEPTION;
5163: End Check_For_Calendar_Term;
5164:

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

5204:
5205: EXCEPTION
5206: WHEN OTHERS then
5207: IF (SQLCODE <> -20001) THEN
5208: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5209: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5210: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5211: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5212: END IF;

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

5205: EXCEPTION
5206: WHEN OTHERS then
5207: IF (SQLCODE <> -20001) THEN
5208: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5209: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5210: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5211: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5212: END IF;
5213: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5210: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

5206: WHEN OTHERS then
5207: IF (SQLCODE <> -20001) THEN
5208: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5209: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5210: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5211: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5212: END IF;
5213: APP_EXCEPTION.RAISE_EXCEPTION;
5214:

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

5207: IF (SQLCODE <> -20001) THEN
5208: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5209: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5210: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5211: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5212: END IF;
5213: APP_EXCEPTION.RAISE_EXCEPTION;
5214:
5215: END Cache_Pay_Group;

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

5251:
5252: EXCEPTION
5253: WHEN OTHERS then
5254: IF (SQLCODE <> -20001) THEN
5255: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5256: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5257: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5259: END IF;

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

5252: EXCEPTION
5253: WHEN OTHERS then
5254: IF (SQLCODE <> -20001) THEN
5255: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5256: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5257: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5259: END IF;
5260: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5257: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

5253: WHEN OTHERS then
5254: IF (SQLCODE <> -20001) THEN
5255: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5256: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5257: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5259: END IF;
5260: APP_EXCEPTION.RAISE_EXCEPTION;
5261:

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

5254: IF (SQLCODE <> -20001) THEN
5255: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5256: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5257: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5259: END IF;
5260: APP_EXCEPTION.RAISE_EXCEPTION;
5261:
5262: END Cache_Payment_Method;

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

5302:
5303: EXCEPTION
5304: WHEN OTHERS then
5305: IF (SQLCODE <> -20001) THEN
5306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5309: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5310: END IF;

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

5303: EXCEPTION
5304: WHEN OTHERS then
5305: IF (SQLCODE <> -20001) THEN
5306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5309: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5310: END IF;
5311: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

5304: WHEN OTHERS then
5305: IF (SQLCODE <> -20001) THEN
5306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5309: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5310: END IF;
5311: APP_EXCEPTION.RAISE_EXCEPTION;
5312:

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

5305: IF (SQLCODE <> -20001) THEN
5306: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5307: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5308: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5309: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5310: END IF;
5311: APP_EXCEPTION.RAISE_EXCEPTION;
5312:
5313: END Cache_Fnd_Currency;