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.AP_HOLD_CODES_PKG dependencies on FND_MESSAGE

Line 31: FND_MESSAGE.SET_NAME('SQLAP', 'AP_ALL_DUPLICATE_VALUE');

27: WHERE upper(hold_lookup_code) = upper(X_Hold_Lookup_Code)
28: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
29:
30: IF (Dummy >= 1) then
31: FND_MESSAGE.SET_NAME('SQLAP', 'AP_ALL_DUPLICATE_VALUE');
32: APP_EXCEPTION.RAISE_EXCEPTION;
33: END IF;
34:
35: EXCEPTION

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

34:
35: EXCEPTION
36: WHEN OTHERS THEN
37: IF (SQLCODE <> -20001) THEN
38: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
39: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
42: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

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

35: EXCEPTION
36: WHEN OTHERS THEN
37: IF (SQLCODE <> -20001) THEN
38: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
39: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
42: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
43: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

36: WHEN OTHERS THEN
37: IF (SQLCODE <> -20001) THEN
38: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
39: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
42: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
43: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
44: END IF;

Line 41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

37: IF (SQLCODE <> -20001) THEN
38: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
39: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
42: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
43: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
44: END IF;
45: APP_EXCEPTION.RAISE_EXCEPTION;

Line 43: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

39: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
40: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
41: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
42: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
43: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
44: END IF;
45: APP_EXCEPTION.RAISE_EXCEPTION;
46:
47: END CHECK_UNIQUE;

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

221:
222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (SQLCODE <> -20001) THEN
225: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
226: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
229: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

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

222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (SQLCODE <> -20001) THEN
225: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
226: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
229: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

223: WHEN OTHERS THEN
224: IF (SQLCODE <> -20001) THEN
225: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
226: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
229: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
231: END IF;

Line 228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

224: IF (SQLCODE <> -20001) THEN
225: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
226: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
229: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
231: END IF;
232: APP_EXCEPTION.RAISE_EXCEPTION;

Line 230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

226: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
227: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
228: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
229: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
231: END IF;
232: APP_EXCEPTION.RAISE_EXCEPTION;
233:
234: END Insert_Row;

Line 278: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

274:
275: FETCH C INTO Recinfo;
276: if (C%NOTFOUND) then
277: CLOSE C;
278: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
279: APP_EXCEPTION.Raise_Exception;
280: end if;
281:
282: debug_info := 'Close cursor C';

Line 318: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

314: AND (X_hold_instruction IS NULL)))
315: ) then
316: return;
317: else
318: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
319: APP_EXCEPTION.Raise_Exception;
320: end if;
321:
322: EXCEPTION

Line 326: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');

322: EXCEPTION
323: WHEN OTHERS THEN
324: IF (SQLCODE <> -20001) THEN
325: IF (SQLCODE = -54) THEN
326: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
327: ELSE
328: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

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

324: IF (SQLCODE <> -20001) THEN
325: IF (SQLCODE = -54) THEN
326: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
327: ELSE
328: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
332: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

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

325: IF (SQLCODE = -54) THEN
326: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
327: ELSE
328: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
332: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

326: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
327: ELSE
328: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
332: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
334: END IF;

Line 331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

327: ELSE
328: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
332: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
334: END IF;
335: END IF;

Line 333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

329: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
330: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
331: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
332: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
334: END IF;
335: END IF;
336: APP_EXCEPTION.RAISE_EXCEPTION;
337:

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

418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

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

419: EXCEPTION
420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;

Line 425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;
429: APP_EXCEPTION.RAISE_EXCEPTION;

Line 427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

423: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
424: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
425: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
426: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
427: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
428: END IF;
429: APP_EXCEPTION.RAISE_EXCEPTION;
430:
431: END Update_Row;