141: FOR I IN 1..l_msg_count
142: LOOP
143: l_error_msg := FND_MSG_PUB.Get(p_msg_index => I,
144: p_encoded => 'T');
145: FND_MESSAGE.Set_Encoded(l_error_msg);
146: END LOOP;
147: END IF;
148:
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
145: FND_MESSAGE.Set_Encoded(l_error_msg);
146: END LOOP;
147: END IF;
148:
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
151: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
152: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
153: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
146: END LOOP;
147: END IF;
148:
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
151: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
152: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
153: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
154: ||',X_vendor_Site_id: '||X_vendor_site_id);
147: END IF;
148:
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
151: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
152: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
153: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
154: ||',X_vendor_Site_id: '||X_vendor_site_id);
155: --
148:
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
151: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
152: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
153: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
154: ||',X_vendor_Site_id: '||X_vendor_site_id);
155: --
156: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
151: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
152: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
153: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
154: ||',X_vendor_Site_id: '||X_vendor_site_id);
155: --
156: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'IBY_API_ERROR');
158: END IF;
159: --
160: WHEN OTHERS THEN
161: IF (SQLCODE <> -20001 ) THEN
162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
163: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
165: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
166: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
159: --
160: WHEN OTHERS THEN
161: IF (SQLCODE <> -20001 ) THEN
162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
163: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
165: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
166: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
167: ||',X_vendor_Site_id: '||X_vendor_site_id);
160: WHEN OTHERS THEN
161: IF (SQLCODE <> -20001 ) THEN
162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
163: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
165: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
166: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
167: ||',X_vendor_Site_id: '||X_vendor_site_id);
168: END IF;
161: IF (SQLCODE <> -20001 ) THEN
162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
163: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
165: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
166: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
167: ||',X_vendor_Site_id: '||X_vendor_site_id);
168: END IF;
169: --
162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
163: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
164: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
165: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
166: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Vendor_Id: '||X_Vendor_Id
167: ||',X_vendor_Site_id: '||X_vendor_site_id);
168: END IF;
169: --
170: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
256: FOR I IN 1..l_msg_count
257: LOOP
258: l_error_msg := FND_MSG_PUB.Get(p_msg_index => I,
259: p_encoded => 'T');
260: FND_MESSAGE.Set_Encoded(l_error_msg);
261: END LOOP;
262: END IF;
263:
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
260: FND_MESSAGE.Set_Encoded(l_error_msg);
261: END LOOP;
262: END IF;
263:
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
266: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
267: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
268: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
261: END LOOP;
262: END IF;
263:
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
266: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
267: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
268: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
269: ||',X_Party_Site_id: '||X_Party_site_id);
262: END IF;
263:
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
266: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
267: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
268: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
269: ||',X_Party_Site_id: '||X_Party_site_id);
270: --
263:
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
266: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
267: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
268: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
269: ||',X_Party_Site_id: '||X_Party_site_id);
270: --
271: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
266: FND_MESSAGE.SET_TOKEN('MSG_COUNT', l_msg_count );
267: FND_MESSAGE.SET_TOKEN('MSG_DATA', l_debug_info );
268: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
269: ||',X_Party_Site_id: '||X_Party_site_id);
270: --
271: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
272: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'IBY_API_ERROR');
273: END IF;
274: --
275: WHEN OTHERS THEN
276: IF (SQLCODE <> -20001 ) THEN
277: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
280: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
281: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
274: --
275: WHEN OTHERS THEN
276: IF (SQLCODE <> -20001 ) THEN
277: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
280: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
281: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
282: ||',X_party_Site_id: '||X_party_site_id);
275: WHEN OTHERS THEN
276: IF (SQLCODE <> -20001 ) THEN
277: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
280: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
281: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
282: ||',X_party_Site_id: '||X_party_site_id);
283: END IF;
276: IF (SQLCODE <> -20001 ) THEN
277: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
280: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
281: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
282: ||',X_party_Site_id: '||X_party_site_id);
283: END IF;
284: --
277: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM );
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
280: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
281: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Party_Id: '||X_Party_Id
282: ||',X_party_Site_id: '||X_party_site_id);
283: END IF;
284: --
285: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN