APPS.XTR_XTRUPREP_XMLP_PKG dependencies on FND_MESSAGE

Line 30: FND_MESSAGE.SET_NAME('XTR'

26: XTR_CFLOW_REQUEST_DETAILS CFREQ
27: WHERE CFREQ.CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;
28: EXCEPTION
29: WHEN OTHERS THEN
30: FND_MESSAGE.SET_NAME('XTR'
31: ,'XTR_2035');
32: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
33: P_NO_RECORDS_UPDATED := 'Y';
34: END;

Line 32: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

28: EXCEPTION
29: WHEN OTHERS THEN
30: FND_MESSAGE.SET_NAME('XTR'
31: ,'XTR_2035');
32: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
33: P_NO_RECORDS_UPDATED := 'Y';
34: END;
35: IF (P_NO_RECORDS_UPDATED = 'N') THEN
36: BEGIN

Line 45: FND_MESSAGE.SET_NAME('XTR'

41: XTR_CFLOW_UPDATED_RECORDS
42: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;
43: EXCEPTION
44: WHEN OTHERS THEN
45: FND_MESSAGE.SET_NAME('XTR'
46: ,'XTR_2035');
47: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
48: P_NO_RECORDS_UPDATED := 'Y';
49: END;

Line 47: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

43: EXCEPTION
44: WHEN OTHERS THEN
45: FND_MESSAGE.SET_NAME('XTR'
46: ,'XTR_2035');
47: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
48: P_NO_RECORDS_UPDATED := 'Y';
49: END;
50: IF (L_COUNT = 0) THEN
51: FND_MESSAGE.SET_NAME('XTR'

Line 51: FND_MESSAGE.SET_NAME('XTR'

47: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
48: P_NO_RECORDS_UPDATED := 'Y';
49: END;
50: IF (L_COUNT = 0) THEN
51: FND_MESSAGE.SET_NAME('XTR'
52: ,'XTR_2035');
53: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
54: P_NO_RECORDS_UPDATED := 'Y';
55: END IF;

Line 53: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

49: END;
50: IF (L_COUNT = 0) THEN
51: FND_MESSAGE.SET_NAME('XTR'
52: ,'XTR_2035');
53: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
54: P_NO_RECORDS_UPDATED := 'Y';
55: END IF;
56: END IF;
57: IF (P_NO_RECORDS_UPDATED = 'N') THEN

Line 68: FND_MESSAGE.SET_NAME('XTR'

64: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
65: AND MESSAGE_NAME = 'XTR_CFLOW_ACCT_UNAUTHORIZED';
66: IF (NVL(P_NO_RECORDS_UPDATED
67: ,'N') = 'Y') THEN
68: FND_MESSAGE.SET_NAME('XTR'
69: ,'XTR_CFLOW_ACCT_UNAUTHORIZED');
70: FND_MESSAGE.SET_TOKEN('BANK_ACCOUNT_NUMBER'
71: ,P_NEW_ACCOUNT);
72: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

Line 70: FND_MESSAGE.SET_TOKEN('BANK_ACCOUNT_NUMBER'

66: IF (NVL(P_NO_RECORDS_UPDATED
67: ,'N') = 'Y') THEN
68: FND_MESSAGE.SET_NAME('XTR'
69: ,'XTR_CFLOW_ACCT_UNAUTHORIZED');
70: FND_MESSAGE.SET_TOKEN('BANK_ACCOUNT_NUMBER'
71: ,P_NEW_ACCOUNT);
72: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
73: END IF;
74: EXCEPTION

Line 72: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

68: FND_MESSAGE.SET_NAME('XTR'
69: ,'XTR_CFLOW_ACCT_UNAUTHORIZED');
70: FND_MESSAGE.SET_TOKEN('BANK_ACCOUNT_NUMBER'
71: ,P_NEW_ACCOUNT);
72: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
73: END IF;
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: P_NO_RECORDS_UPDATED := 'N';

Line 90: FND_MESSAGE.SET_NAME('XTR'

86: WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
87: AND MESSAGE_NAME = 'XTR_CFLOW_CURRENCY_MISMATCH';
88: IF (NVL(P_NO_RECORDS_UPDATED
89: ,'N') = 'Y') THEN
90: FND_MESSAGE.SET_NAME('XTR'
91: ,'XTR_CFLOW_CURRENCY_MISMATCH');
92: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
93: END IF;
94: EXCEPTION

Line 92: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;

88: IF (NVL(P_NO_RECORDS_UPDATED
89: ,'N') = 'Y') THEN
90: FND_MESSAGE.SET_NAME('XTR'
91: ,'XTR_CFLOW_CURRENCY_MISMATCH');
92: P_MESSAGE_TEXT_FOR_NO_RECORDS := FND_MESSAGE.GET;
93: END IF;
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: P_NO_RECORDS_UPDATED := 'N';

Line 100: FND_MESSAGE.SET_NAME('XTR'

96: P_NO_RECORDS_UPDATED := 'N';
97: END;
98: END IF;
99: IF (P_NO_RECORDS_UPDATED = 'N') THEN
100: FND_MESSAGE.SET_NAME('XTR'
101: ,'XTR_CFLOW_UPDATED');
102: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
103: ,P_NEW_ACCOUNT);
104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;

Line 102: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'

98: END IF;
99: IF (P_NO_RECORDS_UPDATED = 'N') THEN
100: FND_MESSAGE.SET_NAME('XTR'
101: ,'XTR_CFLOW_UPDATED');
102: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
103: ,P_NEW_ACCOUNT);
104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;
105: FND_MESSAGE.SET_NAME('XTR'
106: ,'XTR_CFLOW_NOT_UPDATED');

Line 104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;

100: FND_MESSAGE.SET_NAME('XTR'
101: ,'XTR_CFLOW_UPDATED');
102: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
103: ,P_NEW_ACCOUNT);
104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;
105: FND_MESSAGE.SET_NAME('XTR'
106: ,'XTR_CFLOW_NOT_UPDATED');
107: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
108: ,P_NEW_ACCOUNT);

Line 105: FND_MESSAGE.SET_NAME('XTR'

101: ,'XTR_CFLOW_UPDATED');
102: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
103: ,P_NEW_ACCOUNT);
104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;
105: FND_MESSAGE.SET_NAME('XTR'
106: ,'XTR_CFLOW_NOT_UPDATED');
107: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
108: ,P_NEW_ACCOUNT);
109: P_MESSAGE_CODE_FOR_ERROR := FND_MESSAGE.GET;

Line 107: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'

103: ,P_NEW_ACCOUNT);
104: P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;
105: FND_MESSAGE.SET_NAME('XTR'
106: ,'XTR_CFLOW_NOT_UPDATED');
107: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
108: ,P_NEW_ACCOUNT);
109: P_MESSAGE_CODE_FOR_ERROR := FND_MESSAGE.GET;
110: END IF;
111: END;

Line 109: P_MESSAGE_CODE_FOR_ERROR := FND_MESSAGE.GET;

105: FND_MESSAGE.SET_NAME('XTR'
106: ,'XTR_CFLOW_NOT_UPDATED');
107: FND_MESSAGE.SET_TOKEN('ACCOUNT_NUMBER'
108: ,P_NEW_ACCOUNT);
109: P_MESSAGE_CODE_FOR_ERROR := FND_MESSAGE.GET;
110: END IF;
111: END;
112: RETURN (TRUE);
113: END BEFOREREPORT;