DBA Data[Home] [Help]

APPS.AP_WEB_SIGNING_LIMITS_PKG dependencies on FND_MESSAGE

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

57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: IF (SQLCODE <> -20001) THEN
61: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
62: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
63: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
64: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
65: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||

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

58: EXCEPTION
59: WHEN OTHERS THEN
60: IF (SQLCODE <> -20001) THEN
61: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
62: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
63: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
64: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
65: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
66: ',X_COST_CENTER='||X_COST_CENTER||

Line 63: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||

59: WHEN OTHERS THEN
60: IF (SQLCODE <> -20001) THEN
61: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
62: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
63: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
64: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
65: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
66: ',X_COST_CENTER='||X_COST_CENTER||
67: ',X_SIGNING_LIMIT='||X_SIGNING_LIMIT||

Line 74: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','INSERT_ROW HAS EXCEPTION');

70: ',X_LAST_UPDATE_LOGIN='||X_LAST_UPDATE_LOGIN||
71: ',X_CREATION_DATE='||X_CREATION_DATE||
72: ',X_CREATED_BY='||X_CREATED_BY||
73: ',X_ORG_ID='||X_ORG_ID);
74: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','INSERT_ROW HAS EXCEPTION');
75: END IF;
76: APP_EXCEPTION.RAISE_EXCEPTION;
77:
78: END Insert_Row;

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

96: OPEN C;
97: FETCH C INTO Recinfo;
98: if (C%NOTFOUND) then
99: CLOSE C;
100: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
101: APP_EXCEPTION.Raise_Exception;
102: end if;
103: CLOSE C;
104: if (

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

111: OR (X_Org_Id IS NULL))
112: ) then
113: return;
114: else
115: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
116: APP_EXCEPTION.Raise_Exception;
117: end if;
118:
119: EXCEPTION

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

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: IF (SQLCODE <> -20001) THEN
122: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
123: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
124: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
125: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
126: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||

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

119: EXCEPTION
120: WHEN OTHERS THEN
121: IF (SQLCODE <> -20001) THEN
122: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
123: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
124: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
125: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
126: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
127: ',X_COST_CENTER='||X_COST_CENTER||

Line 124: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||

120: WHEN OTHERS THEN
121: IF (SQLCODE <> -20001) THEN
122: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
123: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
124: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
125: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
126: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
127: ',X_COST_CENTER='||X_COST_CENTER||
128: ',X_SIGNING_LIMIT='||X_SIGNING_LIMIT||

Line 130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','LOCK_ROW HAS EXCEPTION');

126: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
127: ',X_COST_CENTER='||X_COST_CENTER||
128: ',X_SIGNING_LIMIT='||X_SIGNING_LIMIT||
129: ',X_ORG_ID='||X_ORG_ID);
130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','LOCK_ROW HAS EXCEPTION');
131: END IF;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END Lock_Row;
134:

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

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: IF (SQLCODE <> -20001) THEN
167: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
168: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
169: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
170: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
171: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||

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

164: EXCEPTION
165: WHEN OTHERS THEN
166: IF (SQLCODE <> -20001) THEN
167: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
168: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
169: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
170: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
171: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
172: ',X_COST_CENTER='||X_COST_CENTER||

Line 169: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||

165: WHEN OTHERS THEN
166: IF (SQLCODE <> -20001) THEN
167: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
168: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
169: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID||
170: ',X_DOCUMENT_TYPE='||X_DOCUMENT_TYPE||
171: ',X_EMPLOYEE_ID='||X_EMPLOYEE_ID||
172: ',X_COST_CENTER='||X_COST_CENTER||
173: ',X_SIGNING_LIMIT='||X_SIGNING_LIMIT||

Line 178: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','UPDATE_ROW HAS EXCEPTION');

174: ',X_LAST_UPDATE_DATE='||X_LAST_UPDATE_DATE||
175: ',X_LAST_UPDATED_BY='||X_LAST_UPDATED_BY||
176: ',X_LAST_UPDATE_LOGIN='||X_LAST_UPDATE_LOGIN||
177: ',X_ORG_ID='||X_ORG_ID);
178: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','UPDATE_ROW HAS EXCEPTION');
179: END IF;
180: APP_EXCEPTION.RAISE_EXCEPTION;
181: END Update_Row;
182:

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

191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: IF (SQLCODE <> -20001) THEN
195: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
197: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID);
198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','DELETE_ROW HAS EXCEPTION');
199: END IF;

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

192: EXCEPTION
193: WHEN OTHERS THEN
194: IF (SQLCODE <> -20001) THEN
195: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
197: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID);
198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','DELETE_ROW HAS EXCEPTION');
199: END IF;
200: APP_EXCEPTION.RAISE_EXCEPTION;

Line 197: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID);

193: WHEN OTHERS THEN
194: IF (SQLCODE <> -20001) THEN
195: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
197: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID);
198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','DELETE_ROW HAS EXCEPTION');
199: END IF;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201: END Delete_Row;

Line 198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','DELETE_ROW HAS EXCEPTION');

194: IF (SQLCODE <> -20001) THEN
195: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
196: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
197: FND_MESSAGE.SET_TOKEN('PARAMENTERS','X_ROWID='||X_ROWID);
198: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','DELETE_ROW HAS EXCEPTION');
199: END IF;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201: END Delete_Row;
202:

Line 230: fnd_message.set_name('SQLAP', 'AP_ALL_DUPLICATE_VALUE');

226: and cost_center = X_cost_center
227: and ((X_rowid is null) or (rowid <> X_rowid));
228:
229: if (dummy_a >= 1) then
230: fnd_message.set_name('SQLAP', 'AP_ALL_DUPLICATE_VALUE');
231: app_exception.raise_exception;
232: end if;
233:
234: EXCEPTION

Line 237: fnd_message.set_name('SQLAP', 'AP_DEBUG');

233:
234: EXCEPTION
235: when OTHERS then
236: if (SQLCODE <> -20001) then
237: fnd_message.set_name('SQLAP', 'AP_DEBUG');
238: fnd_message.set_token('ERROR', sqlerrm);
239: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
240: fnd_message.set_token('PARAMETERS',
241: 'X_Rowid = ' || X_Rowid

Line 238: fnd_message.set_token('ERROR', sqlerrm);

234: EXCEPTION
235: when OTHERS then
236: if (SQLCODE <> -20001) then
237: fnd_message.set_name('SQLAP', 'AP_DEBUG');
238: fnd_message.set_token('ERROR', sqlerrm);
239: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
240: fnd_message.set_token('PARAMETERS',
241: 'X_Rowid = ' || X_Rowid
242: ||', X_Document_Type = ' || X_Document_Type

Line 239: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);

235: when OTHERS then
236: if (SQLCODE <> -20001) then
237: fnd_message.set_name('SQLAP', 'AP_DEBUG');
238: fnd_message.set_token('ERROR', sqlerrm);
239: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
240: fnd_message.set_token('PARAMETERS',
241: 'X_Rowid = ' || X_Rowid
242: ||', X_Document_Type = ' || X_Document_Type
243: ||', X_Employee_Id = ' || X_Employee_Id

Line 240: fnd_message.set_token('PARAMETERS',

236: if (SQLCODE <> -20001) then
237: fnd_message.set_name('SQLAP', 'AP_DEBUG');
238: fnd_message.set_token('ERROR', sqlerrm);
239: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
240: fnd_message.set_token('PARAMETERS',
241: 'X_Rowid = ' || X_Rowid
242: ||', X_Document_Type = ' || X_Document_Type
243: ||', X_Employee_Id = ' || X_Employee_Id
244: ||', X_Cost_Center = ' || X_Cost_Center );

Line 245: fnd_message.set_token('DEBUG_INFO', debug_info);

241: 'X_Rowid = ' || X_Rowid
242: ||', X_Document_Type = ' || X_Document_Type
243: ||', X_Employee_Id = ' || X_Employee_Id
244: ||', X_Cost_Center = ' || X_Cost_Center );
245: fnd_message.set_token('DEBUG_INFO', debug_info);
246: end if;
247: app_exception.raise_exception;
248:
249: end CHECK_UNIQUE;