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.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_DEBUG_PUB

Line 48: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_To_Errors_Table');

44: , p_error_message_text IN VARCHAR2
45: )
46: IS
47: BEGIN
48: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_To_Errors_Table');
49: --
50: -- Insert row into OE_EXP_INTERFACE_ERRORS table
51: --
52: INSERT INTO OE_EXP_INTERFACE_ERRORS (

Line 84: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_To_Errors_Table');

80: , G_program_id
81: , SYSDATE
82: , G_request_id
83: );
84: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_To_Errors_Table');
85: EXCEPTION
86: WHEN OTHERS THEN
87: OE_DEBUG_PUB.Add('Insert_To_Errors_Table: Unexpected Error');
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 87: OE_DEBUG_PUB.Add('Insert_To_Errors_Table: Unexpected Error');

83: );
84: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_To_Errors_Table');
85: EXCEPTION
86: WHEN OTHERS THEN
87: OE_DEBUG_PUB.Add('Insert_To_Errors_Table: Unexpected Error');
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END;
90:
91: --=====================================================================

Line 106: OE_DEBUG_PUB.Add('OEXVECEB: In Is_Currency_Valid');

102: l_return_value BOOLEAN := TRUE;
103: l_curr_valid NUMBER;
104: l_message_text VARCHAR2(2000);
105: BEGIN
106: OE_DEBUG_PUB.Add('OEXVECEB: In Is_Currency_Valid');
107: BEGIN
108: SELECT 1
109: INTO l_curr_valid
110: FROM fnd_currencies

Line 119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);

115: AND NVL(end_date_active, TO_DATE('31/12/9999','DD/MM/YYYY'))
116: >= TRUNC(SYSDATE) ;
117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.', 5);
120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;

Line 124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);

120: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CURRENCY_INVALID');
121: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME','CURRENCY_CODE');
122: FND_MESSAGE.SET_TOKEN ('COLUMN_VALUE', p_exposure_rec.currency_code);
123: l_message_text := FND_MESSAGE.GET;
124: OE_DEBUG_PUB.Add('Error: Currency invalid', 5);
125: Insert_To_Errors_Table(
126: p_exposure_source_code => p_exposure_rec.exposure_source_code
127: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
128: , p_batch_id => p_exposure_rec.batch_id

Line 134: OE_DEBUG_PUB.Add('OEXVECEB: Out Is_Currency_Valid');

130: , p_error_message_text => l_message_text
131: );
132: l_return_value := FALSE;
133: END;
134: OE_DEBUG_PUB.Add('OEXVECEB: Out Is_Currency_Valid');
135: RETURN l_return_value;
136: EXCEPTION
137: WHEN OTHERS THEN
138: OE_DEBUG_PUB.Add('Is_Currency_Valid: Unexpected Error');

Line 138: OE_DEBUG_PUB.Add('Is_Currency_Valid: Unexpected Error');

134: OE_DEBUG_PUB.Add('OEXVECEB: Out Is_Currency_Valid');
135: RETURN l_return_value;
136: EXCEPTION
137: WHEN OTHERS THEN
138: OE_DEBUG_PUB.Add('Is_Currency_Valid: Unexpected Error');
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END Is_Currency_Valid;
141:
142: --=====================================================================

Line 236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);

232: l_message_text VARCHAR2(2000);
233: l_bill_to_state VARCHAR2(60);
234:
235: BEGIN
236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);
237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);

Line 237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);

233: l_bill_to_state VARCHAR2(60);
234:
235: BEGIN
236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);
237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);

Line 238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);

234:
235: BEGIN
236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);
237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);

Line 239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);

235: BEGIN
236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);
237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);

Line 240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);

236: OE_DEBUG_PUB.Add('OEXVECEB: In Address_Value_To_ID', 4);
237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);
244:

Line 241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);

237: OE_DEBUG_PUB.Add('bill_to_customer_id: '||p_exposure_rec.bill_to_customer_id, 5);
238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);
244:
245: l_customer_relations:= OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

Line 242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);

238: OE_DEBUG_PUB.Add('bill_to_address1 : '||p_exposure_rec.bill_to_address1, 5);
239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);
244:
245: l_customer_relations:= OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
246: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations, 5);

Line 243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);

239: OE_DEBUG_PUB.Add('bill_to_address2 : '||p_exposure_rec.bill_to_address2, 5);
240: OE_DEBUG_PUB.Add('bill_to_address3 : '||p_exposure_rec.bill_to_address3, 5);
241: OE_DEBUG_PUB.Add('bill_to_address4 : '||p_exposure_rec.bill_to_address4, 5);
242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);
244:
245: l_customer_relations:= OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
246: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations, 5);
247: --

Line 246: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations, 5);

242: OE_DEBUG_PUB.Add('bill_to_state : '||p_exposure_rec.bill_to_state, 5);
243: OE_DEBUG_PUB.Add('bill_to_province : '||p_exposure_rec.bill_to_province, 5);
244:
245: l_customer_relations:= OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
246: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations, 5);
247: --
248: -- bug 2346992: Get province if state is NULL or G_MISS_CHAR
249: --
250: IF NVL(p_exposure_rec.bill_to_state, FND_API.G_MISS_CHAR) =

Line 257: OE_DEBUG_PUB.Add('l_bill_to_state : '||l_bill_to_state, 5);

253: l_bill_to_state := p_exposure_rec.bill_to_province;
254: ELSE
255: l_bill_to_state := p_exposure_rec.bill_to_state;
256: END IF;
257: OE_DEBUG_PUB.Add('l_bill_to_state : '||l_bill_to_state, 5);
258:
259: IF l_customer_relations = 'N' THEN
260: OPEN c_bill_to_site_use_id(l_bill_to_state);
261: FETCH c_bill_to_site_use_id

Line 301: OE_DEBUG_PUB.Add('Found', 5);

297: FETCH C1
298: INTO l_bill_to_site_use_id;
299:
300: IF C1%FOUND then
301: OE_DEBUG_PUB.Add('Found', 5);
302: -- Check for more than one site use
303: FETCH C1
304: INTO l_bill_to_site_use_id2;
305: IF C1%FOUND THEN

Line 311: oe_debug_pub.add('not found', 5);

307: END IF;
308: CLOSE C1;
309: RETURN l_bill_to_site_use_id;
310: ELSE
311: oe_debug_pub.add('not found', 5);
312: --MOAC Changes
313: /*select userenv('CLIENT_INFO') into l_org from dual;
314: oe_debug_pub.add('org='||l_org, 5);*/
315: --MOAC Changes

Line 314: oe_debug_pub.add('org='||l_org, 5);*/

310: ELSE
311: oe_debug_pub.add('not found', 5);
312: --MOAC Changes
313: /*select userenv('CLIENT_INFO') into l_org from dual;
314: oe_debug_pub.add('org='||l_org, 5);*/
315: --MOAC Changes
316: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
317: INTO l_bill_to_site_use_id
318: FROM OE_INVOICE_TO_ORGS_V

Line 339: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);

335: SELECT CUST_ACCOUNT_ID
336: FROM HZ_CUST_ACCT_RELATE
337: WHERE RELATED_CUST_ACCOUNT_ID = p_exposure_rec.bill_to_customer_id
338: AND bill_to_flag = 'Y');
339: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
340: END IF;
341:
342: CLOSE C1;
343: oe_debug_pub.add('returning from the function', 5);

Line 343: oe_debug_pub.add('returning from the function', 5);

339: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
340: END IF;
341:
342: CLOSE C1;
343: oe_debug_pub.add('returning from the function', 5);
344: RETURN l_bill_to_site_use_id;
345: ELSIF l_customer_relations = 'A' THEN
346: OPEN C2(l_bill_to_state);
347: FETCH C2

Line 397: OE_DEBUG_PUB.Add('Error: No valid address found', 5);

393: END IF;
394:
395: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_INVALID');
396: l_message_text := FND_MESSAGE.Get;
397: OE_DEBUG_PUB.Add('Error: No valid address found', 5);
398: Insert_To_Errors_Table(
399: p_exposure_source_code => p_exposure_rec.exposure_source_code
400: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
401: , p_batch_id => p_exposure_rec.batch_id

Line 406: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID', 5);

402: , p_error_message_name => 'OE_CC_IMP_BILL_TO_ADDR_INVALID'
403: , p_error_message_text => l_message_text
404: );
405:
406: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID', 5);
407: RETURN FND_API.G_MISS_NUM;
408: WHEN TOO_MANY_ROWS THEN
409: IF c_bill_to_site_use_id%ISOPEN then
410: CLOSE c_bill_to_site_use_id;

Line 423: OE_DEBUG_PUB.Add('Error: Found multiple addresses', 5);

419: END IF;
420:
421: FND_MESSAGE.SET_NAME('ONT','OE_CC_IMP_BILL_TO_ADDR_MULTI');
422: l_message_text := FND_MESSAGE.Get;
423: OE_DEBUG_PUB.Add('Error: Found multiple addresses', 5);
424: Insert_To_Errors_Table(
425: p_exposure_source_code => p_exposure_rec.exposure_source_code
426: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
427: , p_batch_id => p_exposure_rec.batch_id

Line 431: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID', 5);

427: , p_batch_id => p_exposure_rec.batch_id
428: , p_error_message_name => 'OE_CC_IMP_BILL_TO_ADDR_MULTI'
429: , p_error_message_text => l_message_text
430: );
431: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID', 5);
432:
433: RETURN FND_API.G_MISS_NUM;
434: WHEN OTHERS THEN
435: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID', 5);

Line 435: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID', 5);

431: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID', 5);
432:
433: RETURN FND_API.G_MISS_NUM;
434: WHEN OTHERS THEN
435: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID', 5);
436: IF c_bill_to_site_use_id%ISOPEN then
437: CLOSE c_bill_to_site_use_id;
438: END IF;
439:

Line 476: OE_DEBUG_PUB.Add('OEXVECEB: In Get_Bill_To_Site_Use_ID', 4);

472: l_bill_to_customer_id NUMBER;
473: l_message_text VARCHAR2(2000);
474: l_exposure_rec oe_exposure_interface%ROWTYPE;
475: BEGIN
476: OE_DEBUG_PUB.Add('OEXVECEB: In Get_Bill_To_Site_Use_ID', 4);
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: /* Added the following line to fix the bug 6451056 */
480:

Line 505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);

501: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_ID_INVALID');
502: FND_MESSAGE.Set_Token('COLUMN_NAME' , 'BILL_TO_SITE_USE_ID');
503: FND_MESSAGE.Set_Token('COLUMN_VALUE', p_exposure_rec.bill_to_site_use_id);
504: l_message_text := FND_MESSAGE.Get;
505: OE_DEBUG_PUB.Add('Error: Bill-to site use ID invalid', 5);
506: Insert_To_Errors_Table(
507: p_exposure_source_code => p_exposure_rec.exposure_source_code
508: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
509: , p_batch_id => p_exposure_rec.batch_id

Line 528: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);

524: (
525: p_exposure_rec => p_exposure_rec
526: );
527: l_bill_to_customer_id := p_exposure_rec.bill_to_customer_id;
528: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
529: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
530: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;

Line 529: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);

525: p_exposure_rec => p_exposure_rec
526: );
527: l_bill_to_customer_id := p_exposure_rec.bill_to_customer_id;
528: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
529: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
530: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: ELSIF p_exposure_rec.bill_to_customer_name IS NOT NULL AND

Line 554: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);

550: (
551: p_exposure_rec => p_exposure_rec
552: );
553:
554: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
555: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
556: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;

Line 555: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);

551: p_exposure_rec => p_exposure_rec
552: );
553:
554: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
555: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
556: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: EXCEPTION

Line 566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);

562: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_CUST_INFO_INVALID');
563: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
564: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
565: l_message_text := FND_MESSAGE.Get;
566: OE_DEBUG_PUB.Add('Error: Customer ID cannot be derived from customer name and number', 5);
567: Insert_To_Errors_Table(
568: p_exposure_source_code => p_exposure_rec.exposure_source_code
569: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
570: , p_batch_id => p_exposure_rec.batch_id

Line 583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);

579: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NAME', 'BILL_TO_CUSTOMER_NAME' );
580: FND_MESSAGE.SET_TOKEN ('CUSTOMER_NUMBER', 'BILL_TO_CUSTOMER_NUMBER' );
581: FND_MESSAGE.SET_TOKEN ('CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID');
582: l_message_text := FND_MESSAGE.Get;
583: OE_DEBUG_PUB.Add('Error: No customer information provided', 5);
584: Insert_To_Errors_Table(
585: p_exposure_source_code => p_exposure_rec.exposure_source_code
586: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id
587: , p_batch_id => p_exposure_rec.batch_id

Line 599: OE_DEBUG_PUB.Add('Error: Insufficient information provided to derive site use ID', 5);

595: -- Either the bill_to site use ID needs to be provided or the bill-to address.
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SITE_USE_INF_INVALID');
598: l_message_text := FND_MESSAGE.Get;
599: OE_DEBUG_PUB.Add('Error: Insufficient information provided to derive site use ID', 5);
600:
601: Insert_To_Errors_Table(
602: p_exposure_source_code => p_exposure_rec.exposure_source_code
603: , p_exposure_interface_id => p_exposure_rec.exposure_interface_id

Line 616: OE_DEBUG_PUB.Add('OEXVECEB: Out Get_Bill_To_Site_Use_ID', 4);

612: x_bill_to_customer_id := l_bill_to_customer_id;
613: -- x_org_id := G_org_id; -- MOAC
614: x_org_id := p_exposure_rec.org_id;
615:
616: OE_DEBUG_PUB.Add('OEXVECEB: Out Get_Bill_To_Site_Use_ID', 4);
617: EXCEPTION
618: WHEN OTHERS THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END Get_Bill_To_Site_Use_ID;

Line 664: OE_DEBUG_PUB.Add('OEXVECEB: In Validate_Exposure_Source ');

660: l_message_text oe_exp_interface_errors.error_message%TYPE;
661: l_source_valid NUMBER;
662: l_any_op_code_errors BOOLEAN := FALSE;
663: BEGIN
664: OE_DEBUG_PUB.Add('OEXVECEB: In Validate_Exposure_Source ');
665: --l_result_out := 'PASS';
666: FOR l_row IN c_exposure_source LOOP
667: --
668: -- Check the exposure source code

Line 688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);

684: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_SOURCE_INVALID');
685: FND_MESSAGE.Set_Token ('COLUMN_NAME','EXPOSURE_SOURCE_CODE');
686: FND_MESSAGE.Set_Token ('COLUMN_VALUE', l_row.exposure_source_code);
687: l_message_text := FND_MESSAGE.Get;
688: OE_DEBUG_PUB.Add('Error: Exposure source code is not valid', 2);
689: Insert_To_Errors_Table(
690: p_exposure_source_code => l_row.exposure_source_code
691: , p_exposure_interface_id => NULL
692: , p_batch_id => NULL

Line 710: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||

706: OPEN c_multi_op_code(l_row.exposure_source_code);
707: FETCH c_multi_op_code INTO l_op_code_count;
708:
709: IF c_multi_op_code%FOUND THEN
710: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
711: ' contains multiple operation codes', 2);
712: -- write message to errors table
713: l_any_op_code_errors := TRUE;
714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');

Line 716: OE_DEBUG_PUB.Add('Error: Exposure source contains multiple operation codes', 2);

712: -- write message to errors table
713: l_any_op_code_errors := TRUE;
714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
715: l_message_text := FND_MESSAGE.Get;
716: OE_DEBUG_PUB.Add('Error: Exposure source contains multiple operation codes', 2);
717: ELSE
718: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
719: ' contains 1 operation code', 2);
720: -- check for invalid operation code

Line 718: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||

714: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
715: l_message_text := FND_MESSAGE.Get;
716: OE_DEBUG_PUB.Add('Error: Exposure source contains multiple operation codes', 2);
717: ELSE
718: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
719: ' contains 1 operation code', 2);
720: -- check for invalid operation code
721: OPEN c_invalid_op_code(l_row.exposure_source_code);
722: FETCH c_invalid_op_code INTO l_operation_code;

Line 725: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||

721: OPEN c_invalid_op_code(l_row.exposure_source_code);
722: FETCH c_invalid_op_code INTO l_operation_code;
723: IF c_invalid_op_code%FOUND THEN
724: l_any_op_code_errors := TRUE;
725: OE_DEBUG_PUB.Add('Exposure source code '||l_row.exposure_source_code||
726: ' contains an invalid operation code', 2);
727: -- write message to errors table
728: FND_MESSAGE.Set_Name('ONT', 'OE_CC_IMP_OP_CODE_MULTIPLE');
729: l_message_text := FND_MESSAGE.Get;

Line 757: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure_Source ');

753:
754: COMMIT;
755: END IF;
756: END LOOP; -- end of check of exposure source codes
757: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure_Source ');
758: EXCEPTION
759: WHEN OTHERS THEN
760: IF c_multi_op_code%ISOPEN THEN
761: CLOSE c_multi_op_code;

Line 769: OE_DEBUG_PUB.Add('Validate_Exposure_Source -- Unexpected Error');

765: END IF;
766: IF c_exposure_source%ISOPEN THEN
767: CLOSE c_exposure_source;
768: END IF;
769: OE_DEBUG_PUB.Add('Validate_Exposure_Source -- Unexpected Error');
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END Validate_Exposure_Source;
772:
773: --=====================================================================

Line 799: OE_DEBUG_PUB.Add('OEXVECEB: In Validate_Exposure');

795: l_return_status VARCHAR2(30);
796: l_org_id NUMBER;
797: l_result_out VARCHAR2(30);
798: BEGIN
799: OE_DEBUG_PUB.Add('OEXVECEB: In Validate_Exposure');
800: --
801: -- Validate Operation Code. Should be the same within a given exposure source
802: --
803: Validate_Exposure_Source;

Line 810: OE_DEBUG_PUB.Add('Validating interface ID: '||

806: FOR l_exposure_rec IN c_rows_to_process LOOP
807: --
808: -- Validate each row
809: --
810: OE_DEBUG_PUB.Add('Validating interface ID: '||
811: l_exposure_rec.exposure_interface_id, 4);
812: l_bill_to_site_use_id := l_exposure_rec.bill_to_site_use_id;
813:
814: -- Validate currency code

Line 820: OE_DEBUG_PUB.Add('Validate Currency Failed.', 5);

816: THEN
817: IF NOT l_any_errors THEN
818: l_any_errors := TRUE;
819: END IF;
820: OE_DEBUG_PUB.Add('Validate Currency Failed.', 5);
821: END IF;
822:
823: --
824: -- Derive the bill-to site use ID, the customer ID, and the org ID

Line 837: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);

833: ,x_bill_to_customer_id => l_bill_to_customer_id
834: ,x_org_id => l_org_id
835: );
836:
837: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);
840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);
841:

Line 838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);

834: ,x_org_id => l_org_id
835: );
836:
837: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);
840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);
841:
842: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);

835: );
836:
837: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);
840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);
841:
842: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
843: THEN

Line 840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);

836:
837: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id, 5);
838: OE_DEBUG_PUB.Add('l_bill_to_customer_id: '||l_bill_to_customer_id, 5);
839: OE_DEBUG_PUB.Add('l_org_id : '||l_org_id, 5);
840: OE_DEBUG_PUB.Add('l_return_status : '||l_return_status, 5);
841:
842: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
843: THEN
844: IF NOT l_any_errors THEN

Line 847: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.', 5);

843: THEN
844: IF NOT l_any_errors THEN
845: l_any_errors := TRUE;
846: END IF;
847: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.', 5);
848: END IF;
849:
850: IF l_any_errors THEN
851: OE_DEBUG_PUB.Add('Validation Errors Found', 5);

Line 851: OE_DEBUG_PUB.Add('Validation Errors Found', 5);

847: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.', 5);
848: END IF;
849:
850: IF l_any_errors THEN
851: OE_DEBUG_PUB.Add('Validation Errors Found', 5);
852: UPDATE oe_exposure_interface
853: SET import_status_code = G_ERROR
854: WHERE exposure_interface_id = l_exposure_rec.exposure_interface_id;
855: ELSE

Line 857: OE_DEBUG_PUB.Add(

853: SET import_status_code = G_ERROR
854: WHERE exposure_interface_id = l_exposure_rec.exposure_interface_id;
855: ELSE
856: -- Update status code and IDs and Who Columns
857: OE_DEBUG_PUB.Add(
858: 'No Validation Errors Found. Updating the interface table...', 5);
859: UPDATE oe_exposure_interface
860: SET import_status_code = G_VALIDATED,
861: bill_to_site_use_id = l_bill_to_site_use_id,

Line 877: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure');

873: COMMIT;
874: END IF;
875: END LOOP;
876: -- END IF; -- validation
877: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure');
878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);
881: RAISE;

Line 880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);

876: -- END IF; -- validation
877: OE_DEBUG_PUB.Add('OEXVECEB: Out Validate_Exposure');
878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);
881: RAISE;
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Unexpected Error', 2);
884: RAISE;

Line 883: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Unexpected Error', 2);

879: WHEN FND_API.G_EXC_ERROR THEN
880: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Expected Error', 2);
881: RAISE;
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Unexpected Error', 2);
884: RAISE;
885: WHEN OTHERS THEN
886: IF c_rows_to_process%ISOPEN THEN
887: CLOSE c_rows_to_process;

Line 889: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Other Unexpected Error', 2);

885: WHEN OTHERS THEN
886: IF c_rows_to_process%ISOPEN THEN
887: CLOSE c_rows_to_process;
888: END IF;
889: OE_DEBUG_PUB.Add('OEXVECEB: Validate_Exposure -- Other Unexpected Error', 2);
890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
891: OE_MSG_PUB.Add_Exc_Msg (
892: G_PKG_NAME
893: , 'Validate_Exposure');

Line 923: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_Exposure', 4);

919: AND balance_type = 18;
920:
921: l_row_id VARCHAR2(30);
922: BEGIN
923: OE_DEBUG_PUB.Add('OEXVECEB: In Insert_Exposure', 4);
924: OPEN c_summary_row;
925: FETCH c_summary_row INTO l_row_id;
926:
927: IF c_summary_row%FOUND THEN

Line 929: OE_DEBUG_PUB.Add('Row exist. Delete existing row', 5);

925: FETCH c_summary_row INTO l_row_id;
926:
927: IF c_summary_row%FOUND THEN
928: -- Delete any rows first, then insert.
929: OE_DEBUG_PUB.Add('Row exist. Delete existing row', 5);
930: oe_credit_summaries_pkg.Delete_Row(
931: p_row_id => l_row_id
932: );
933: END IF;

Line 937: OE_DEBUG_PUB.Add('Insert the new exposure row', 5);

933: END IF;
934:
935: IF p_exposure_rec.exposure_amount <> 0 THEN
936: -- Insert row only if amount <> 0
937: OE_DEBUG_PUB.Add('Insert the new exposure row', 5);
938: oe_credit_summaries_pkg.insert_row(
939: p_cust_account_id => p_exposure_rec.bill_to_customer_id
940: , p_org_id => p_exposure_rec.org_id
941: , p_site_use_id => p_exposure_rec.bill_to_site_use_id

Line 958: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_Exposure', 4);

954: , p_exposure_source_code => p_exposure_rec.exposure_source_code
955: );
956: END IF;
957: CLOSE c_summary_row;
958: OE_DEBUG_PUB.Add('OEXVECEB: Out Insert_Exposure', 4);
959: EXCEPTION
960: WHEN OTHERS THEN
961: IF c_summary_row%ISOPEN THEN
962: CLOSE c_summary_row;

Line 993: OE_DEBUG_PUB.Add('OEXVECEB: In Update_Exposure', 4);

989:
990: l_row_id VARCHAR2(30);
991: l_balance NUMBER;
992: BEGIN
993: OE_DEBUG_PUB.Add('OEXVECEB: In Update_Exposure', 4);
994: -- Check if exposure exist in the summary table
995: OPEN c_summary_exposure;
996: FETCH c_summary_exposure INTO l_row_id, l_balance;
997:

Line 1000: OE_DEBUG_PUB.Add('Updating exposure row', 5);

996: FETCH c_summary_exposure INTO l_row_id, l_balance;
997:
998: IF p_exposure_rec.exposure_amount <> 0 THEN
999: IF c_summary_exposure%FOUND THEN
1000: OE_DEBUG_PUB.Add('Updating exposure row', 5);
1001: oe_credit_summaries_pkg.Update_Row(
1002: p_row_id => l_row_id
1003: , p_balance => p_exposure_rec.exposure_amount + l_balance
1004: , p_last_update_date => p_exposure_rec.last_update_date

Line 1013: OE_DEBUG_PUB.Add('Inserting exposure row', 5);

1009: , p_program_update_date => p_exposure_rec.program_update_date
1010: , p_request_id => p_exposure_rec.request_id
1011: );
1012: ELSE
1013: OE_DEBUG_PUB.Add('Inserting exposure row', 5);
1014: oe_credit_summaries_pkg.Insert_Row(
1015: p_cust_account_id => p_exposure_rec.bill_to_customer_id
1016: , p_org_id => p_exposure_rec.org_id
1017: , p_site_use_id => p_exposure_rec.bill_to_site_use_id

Line 1035: OE_DEBUG_PUB.Add('OEXVECEB: Out Update_Exposure', 4);

1031: );
1032: END IF;
1033: END IF;
1034: CLOSE c_summary_exposure;
1035: OE_DEBUG_PUB.Add('OEXVECEB: Out Update_Exposure', 4);
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF c_summary_exposure%ISOPEN THEN
1039: CLOSE c_summary_exposure;

Line 1064: OE_DEBUG_PUB.Add('OEXVECEB: In Import_Exposure');

1060: ORDER BY exposure_source_code;
1061:
1062: l_commitsize_count NUMBER := 0;
1063: BEGIN
1064: OE_DEBUG_PUB.Add('OEXVECEB: In Import_Exposure');
1065: FOR l_exposure_rec IN c_valid_exposures LOOP
1066: IF l_exposure_rec.operation_code = 'INSERT' THEN
1067: Insert_Exposure(l_exposure_rec);
1068: ELSE

Line 1086: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Exposure');

1082: l_commitsize_count := 0;
1083: END IF;
1084: END LOOP;
1085: COMMIT;
1086: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Exposure');
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: OE_DEBUG_PUB.Add('OEXECEB: Import_Exposure -- Unexpected Error');
1090: RAISE;

Line 1089: OE_DEBUG_PUB.Add('OEXECEB: Import_Exposure -- Unexpected Error');

1085: COMMIT;
1086: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Exposure');
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: OE_DEBUG_PUB.Add('OEXECEB: Import_Exposure -- Unexpected Error');
1090: RAISE;
1091: END Import_Exposure;
1092:
1093: --=====================================================================

Line 1137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1133: SELECT ou.organization_id
1134: FROM hr_operating_units ou
1135: WHERE mo_global.check_access(ou.organization_id) = 'Y';
1136:
1137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1138: -- MOAC end
1139:
1140: BEGIN
1141: IF l_debug_level > 0 THEN

Line 1142: OE_DEBUG_PUB.Add('OEXVECEB: In Import_Credit_Exposure');

1138: -- MOAC end
1139:
1140: BEGIN
1141: IF l_debug_level > 0 THEN
1142: OE_DEBUG_PUB.Add('OEXVECEB: In Import_Credit_Exposure');
1143: END IF;
1144: --
1145: -- Show input parameters
1146: --

Line 1147: OE_DEBUG_PUB.Add('* Input Parameters*');

1143: END IF;
1144: --
1145: -- Show input parameters
1146: --
1147: OE_DEBUG_PUB.Add('***** Input Parameters*****');
1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);

Line 1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);

1144: --
1145: -- Show input parameters
1146: --
1147: OE_DEBUG_PUB.Add('***** Input Parameters*****');
1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);
1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);

Line 1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);

1145: -- Show input parameters
1146: --
1147: OE_DEBUG_PUB.Add('***** Input Parameters*****');
1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);
1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);
1153: --

Line 1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);

1146: --
1147: OE_DEBUG_PUB.Add('***** Input Parameters*****');
1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);
1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);
1153: --
1154: -- Check the version and issue an error if the given version does not

Line 1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);

1147: OE_DEBUG_PUB.Add('***** Input Parameters*****');
1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);
1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);
1153: --
1154: -- Check the version and issue an error if the given version does not
1155: -- match the one in this package.

Line 1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);

1148: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1149: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
1150: OE_DEBUG_PUB.Add('p_exposure_source_code: '||p_exposure_source_code);
1151: OE_DEBUG_PUB.Add('p_batch_id: '||p_batch_id);
1152: OE_DEBUG_PUB.Add('p_validate_only: '||p_validate_only);
1153: --
1154: -- Check the version and issue an error if the given version does not
1155: -- match the one in this package.
1156: --

Line 1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);

1164: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));

Line 1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);

1165: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1170: OE_DEBUG_PUB.Add('API Version Check Failed.');

1166: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
1167: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: END IF;

Line 1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));

1168: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
1169: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
1170: OE_DEBUG_PUB.Add('API Version Check Failed.');
1171: l_message_text := FND_MESSAGE.GET;
1172: OE_DEBUG_PUB.Add('message text: '||SUBSTRB(l_message_text, 1, 200));
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: END IF;
1175:
1176: -- MOAC start

Line 1192: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);

1188: AND NVL(org_id, -99) = NVL(l_org_id, -99)
1189: AND import_status_code IS NULL;
1190:
1191: IF l_debug_level > 0 THEN
1192: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1193: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');
1194: END IF;
1195: ELSE
1196: OPEN l_secured_ou_cur;

Line 1193: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');

1189: AND import_status_code IS NULL;
1190:
1191: IF l_debug_level > 0 THEN
1192: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1193: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');
1194: END IF;
1195: ELSE
1196: OPEN l_secured_ou_cur;
1197:

Line 1219: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);

1215: AND NVL(org_id, -99) = NVL(l_org_id, -99)
1216: AND import_status_code IS NULL;
1217:
1218: IF l_debug_level > 0 THEN
1219: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1220: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');
1221: END IF;
1222: END LOOP;
1223:

Line 1220: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');

1216: AND import_status_code IS NULL;
1217:
1218: IF l_debug_level > 0 THEN
1219: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1220: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows updated');
1221: END IF;
1222: END LOOP;
1223:
1224: CLOSE l_secured_ou_cur;

Line 1239: OE_DEBUG_PUB.Add('Selected rows for processing',2);

1235: -- WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1236: -- AND NVL(batch_id, -99) = NVL(p_batch_id, NVL(batch_id,-99))
1237: -- AND import_status_code IS NULL;
1238:
1239: OE_DEBUG_PUB.Add('Selected rows for processing',2);
1240:
1241: --
1242: -- Count the number of rows selected for processing
1243: --

Line 1326: OE_DEBUG_PUB.Add('* Output Parameters *');

1322: x_num_rows_validated := l_num_rows_validated;
1323: x_num_rows_failed := l_num_rows_failed;
1324: x_num_rows_imported := l_num_rows_imported;
1325:
1326: OE_DEBUG_PUB.Add('***** Output Parameters *****');
1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);

Line 1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);

1323: x_num_rows_failed := l_num_rows_failed;
1324: x_num_rows_imported := l_num_rows_imported;
1325:
1326: OE_DEBUG_PUB.Add('***** Output Parameters *****');
1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);
1331: OE_DEBUG_PUB.Add('*****************************');

Line 1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);

1324: x_num_rows_imported := l_num_rows_imported;
1325:
1326: OE_DEBUG_PUB.Add('***** Output Parameters *****');
1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);
1331: OE_DEBUG_PUB.Add('*****************************');
1332:

Line 1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);

1325:
1326: OE_DEBUG_PUB.Add('***** Output Parameters *****');
1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);
1331: OE_DEBUG_PUB.Add('*****************************');
1332:
1333: COMMIT;

Line 1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);

1326: OE_DEBUG_PUB.Add('***** Output Parameters *****');
1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);
1331: OE_DEBUG_PUB.Add('*****************************');
1332:
1333: COMMIT;
1334:

Line 1331: OE_DEBUG_PUB.Add('*****************************');

1327: OE_DEBUG_PUB.Add('x_num_rows_to_process = '||x_num_rows_to_process);
1328: OE_DEBUG_PUB.Add('x_num_rows_validated = '||x_num_rows_validated);
1329: OE_DEBUG_PUB.Add('x_num_rows_failed = '||x_num_rows_failed);
1330: OE_DEBUG_PUB.Add('x_num_rows_imported = '||x_num_rows_imported);
1331: OE_DEBUG_PUB.Add('*****************************');
1332:
1333: COMMIT;
1334:
1335: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Credit_Exposure');

Line 1335: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Credit_Exposure');

1331: OE_DEBUG_PUB.Add('*****************************');
1332:
1333: COMMIT;
1334:
1335: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Credit_Exposure');
1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);

Line 1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);

1335: OE_DEBUG_PUB.Add('OEXVECEB: Out Import_Credit_Exposure');
1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);
1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1341: ROLLBACK;
1342: RAISE;
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);

1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Expected Error',1);
1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1341: ROLLBACK;
1342: RAISE;
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Error',1);

Line 1344: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Error',1);

1340: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1341: ROLLBACK;
1342: RAISE;
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Error',1);
1345: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1346: ROLLBACK;
1347: RAISE;
1348: WHEN OTHERS THEN

Line 1345: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);

1341: ROLLBACK;
1342: RAISE;
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Error',1);
1345: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1346: ROLLBACK;
1347: RAISE;
1348: WHEN OTHERS THEN
1349: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Other Error',1);

Line 1349: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Other Error',1);

1345: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1346: ROLLBACK;
1347: RAISE;
1348: WHEN OTHERS THEN
1349: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Other Error',1);
1350: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1351: ROLLBACK;
1352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1353: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Import_Credit_Exposure');

Line 1350: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);

1346: ROLLBACK;
1347: RAISE;
1348: WHEN OTHERS THEN
1349: OE_DEBUG_PUB.ADD('OEXVECEB: Import_Credit_Exposure - Unexpected Other Error',1);
1350: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200),1);
1351: ROLLBACK;
1352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1353: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Import_Credit_Exposure');
1354: END IF;

Line 1378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1374: FROM hr_operating_units ou
1375: WHERE mo_global.check_access(ou.organization_id) = 'Y';
1376:
1377: l_org_id NUMBER;
1378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1379:
1380: BEGIN
1381: -- MOAC Start
1382: l_org_id := p_org_id;

Line 1385: OE_DEBUG_PUB.Add('OEXVECEB: In Purge');

1381: -- MOAC Start
1382: l_org_id := p_org_id;
1383:
1384: IF l_debug_level > 0 THEN
1385: OE_DEBUG_PUB.Add('OEXVECEB: In Purge');
1386: END IF;
1387:
1388: IF l_org_id IS NOT NULL THEN
1389: MO_GLOBAL.set_policy_context('S', l_org_id);

Line 1397: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);

1393: AND balance_type = 18
1394: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1395:
1396: IF l_debug_level > 0 THEN
1397: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1398: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');
1399: END IF;
1400: ELSE
1401: OPEN l_secured_ou_cur;

Line 1398: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');

1394: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1395:
1396: IF l_debug_level > 0 THEN
1397: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1398: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');
1399: END IF;
1400: ELSE
1401: OPEN l_secured_ou_cur;
1402:

Line 1420: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);

1416: AND balance_type = 18
1417: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1418:
1419: IF l_debug_level > 0 THEN
1420: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1421: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');
1422: END IF;
1423: END LOOP;
1424:

Line 1421: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');

1417: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1418:
1419: IF l_debug_level > 0 THEN
1420: OE_DEBUG_PUB.Add('org_id : ' || l_org_id);
1421: OE_DEBUG_PUB.Add(TO_CHAR(SQL%ROWCOUNT)||' rows purged');
1422: END IF;
1423: END LOOP;
1424:
1425: CLOSE l_secured_ou_cur;

Line 1431: OE_DEBUG_PUB.Add('OEXVECEB: Out Purge');

1427: END IF;
1428: -- MOAC End
1429:
1430: IF l_debug_level > 0 THEN
1431: OE_DEBUG_PUB.Add('OEXVECEB: Out Purge');
1432: END IF;
1433:
1434: COMMIT;
1435: EXCEPTION

Line 1439: OE_DEBUG_PUB.ADD('OEXVECEB: Purge - Unexpected Error');

1435: EXCEPTION
1436: WHEN OTHERS THEN
1437: ROLLBACK;
1438: IF l_debug_level > 0 THEN
1439: OE_DEBUG_PUB.ADD('OEXVECEB: Purge - Unexpected Error');
1440: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200));
1441: END IF;
1442:
1443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1440: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200));

1436: WHEN OTHERS THEN
1437: ROLLBACK;
1438: IF l_debug_level > 0 THEN
1439: OE_DEBUG_PUB.ADD('OEXVECEB: Purge - Unexpected Error');
1440: OE_DEBUG_PUB.ADD('EXCEPTION: '||SUBSTR(sqlerrm,1,200));
1441: END IF;
1442:
1443: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1444: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Purge');