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.IEX_CUST_OVERVIEW_PVT dependencies on IEX_DEBUG_PUB

Line 134: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

130: l_sql_cond VARCHAR2(1000);
131: l_customer_okl_info_rec IEX_CUST_OVERVIEW_PVT.Customer_OKL_Info_Rec_Type;
132: l_calc_cust_stats VARCHAR2(1); -- 5874874 gnramasa
133: BEGIN
134: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
135:
136: l_sql_select := 'SELECT count(1) FROM ';
137: l_sql_where := ' WHERE ';
138: l_sql_cond := ' = :party_id';

Line 220: iex_debug_pub.LogMessage('1. l_delinquency_status :' || l_delinquency_status);

216:
217: IF l_status_rule_id IS NOT NULL THEN
218: FOR r_rule IN c_rule LOOP
219: l_delinquency_status := r_rule.delinquency_status;
220: iex_debug_pub.LogMessage('1. l_delinquency_status :' || l_delinquency_status);
221: IF l_delinquency_status = 'BANKRUPTCY' THEN
222: l_sql_stmt := 'SELECT count(1)' ||
223: ' FROM iex_bankruptcies' ||
224: ' WHERE party_id = :party_id' ||

Line 310: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);

306: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
307: ' AND status = ''PREDELINQUENT''';
308: END IF;
309:
310: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);
311: /*
312: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
313: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
314: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;

Line 313: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);

309:
310: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);
311: /*
312: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
313: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
314: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
315: ELSE
316: */
317: iex_debug_pub.LogMessage('1. l_sql_stmt :' || l_sql_stmt);

Line 317: iex_debug_pub.LogMessage('1. l_sql_stmt :' || l_sql_stmt);

313: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
314: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
315: ELSE
316: */
317: iex_debug_pub.LogMessage('1. l_sql_stmt :' || l_sql_stmt);
318: OPEN c_del FOR l_sql_stmt USING p_party_id;
319: --END IF;
320: --End bug 9861733 gnramasa 19th July 2010
321: FETCH c_del INTO l_count;

Line 347: iex_debug_pub.LogMessage('2. l_delinquency_status :' || l_delinquency_status);

343:
344: IF l_status_rule_id IS NOT NULL THEN
345: FOR r_rule IN c_rule LOOP
346: l_delinquency_status := r_rule.delinquency_status;
347: iex_debug_pub.LogMessage('2. l_delinquency_status :' || l_delinquency_status);
348: IF l_delinquency_status = 'BANKRUPTCY' THEN
349: l_sql_stmt := 'SELECT count(1)' ||
350: ' FROM iex_bankruptcies' ||
351: ' WHERE party_id = :party_id' ||

Line 437: iex_debug_pub.LogMessage('2. p_party_id :' || p_party_id);

433: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
434: ' AND status = ''PREDELINQUENT''';
435: END IF;
436:
437: iex_debug_pub.LogMessage('2. p_party_id :' || p_party_id);
438: /*
439: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
440: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
441: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;

Line 440: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);

436:
437: iex_debug_pub.LogMessage('2. p_party_id :' || p_party_id);
438: /*
439: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
440: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
441: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
442: ELSE
443: */
444: iex_debug_pub.LogMessage('2. l_sql_stmt :' || l_sql_stmt);

Line 444: iex_debug_pub.LogMessage('2. l_sql_stmt :' || l_sql_stmt);

440: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
441: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
442: ELSE
443: */
444: iex_debug_pub.LogMessage('2. l_sql_stmt :' || l_sql_stmt);
445: OPEN c_del FOR l_sql_stmt USING p_party_id;
446: --END IF;
447: --End bug 9861733 gnramasa 19th July 2010
448: --End bug 6723556 gnramasa 10th Jan 2008

Line 475: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

471: END IF;
472: END IF;
473:
474: -- End for bug#7830847
475: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
476: END Get_Customer_Info;
477:
478: PROCEDURE Get_Customer_OKL_Info
479: (p_api_version IN NUMBER := 1.0,

Line 523: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

519: -- and del.status = 'DELINQUENT';
520: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
521:
522: BEGIN
523: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
524:
525: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
526: -- OPEN c_del_cases;
527: -- FETCH c_del_cases INTO x_customer_okl_info_rec.CASES_OVERDUE;

Line 539: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

535: -- FETCH c_del_cases_past_year INTO x_customer_okl_info_rec.NUMBER_OF_DEL_CASES;
536: -- CLOSE c_del_cases_past_year;
537: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
538:
539: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
540: END Get_Customer_OKL_Info;
541:
542: PROCEDURE Get_Object_Info
543: (p_api_version IN NUMBER := 1.0,

Line 590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

586:
587: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
588:
589: BEGIN
590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
591: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||
592: ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id);
593:
594: --start moac change

Line 591: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||

587: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
588:
589: BEGIN
590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
591: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||
592: ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id);
593:
594: --start moac change
595: --to check whether all the ou's has the same functional currency or not

Line 1129: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

1125: end if; --end if for check on count of currency codes(moac change).
1126:
1127: x_object_info_rec.amount_overdue_curr := x_object_info_rec.current_balance_curr;
1128:
1129: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1130:
1131: END Get_Object_Info;
1132:
1133: PROCEDURE Get_Last_Payment_Info

Line 1192: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

1188: l_show_last_pmt_due VARCHAR2(240);
1189: --End-fix bug #5407151-JYPARK-08012006-hide last payment due on depending on profile IEX_SHOW_LAST_PMT_DUE
1190:
1191: BEGIN
1192: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1193:
1194: --Begin - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1195: --First we will find the PK for the record with the info we want
1196: BEGIN

Line 1259: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);

1255: END IF;
1256:
1257: l_pk_query := l_pk_query || l_pk_from || l_pk_where || l_pk_group;
1258:
1259: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1260:
1261: -- Open ref cursor for the query
1262: OPEN cv FOR l_pk_query USING p_object_id;
1263: FETCH cv INTO l_partyid, l_account, l_site, l_org, l_currency, l_pay_date;

Line 1266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);

1262: OPEN cv FOR l_pk_query USING p_object_id;
1263: FETCH cv INTO l_partyid, l_account, l_site, l_org, l_currency, l_pay_date;
1264: CLOSE cv;
1265:
1266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1267:
1268: -- Now we have the primary key to our info, get the data
1269:
1270: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');

Line 1270: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');

1266: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1267:
1268: -- Now we have the primary key to our info, get the data
1269:
1270: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1271:
1272: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1273: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);

Line 1274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);

1270: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1271:
1272: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1273: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);
1275:
1276: IF l_show_last_pmt_due = 'Y' THEN
1277: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';
1278: l_data_query := l_data_query || ' DECODE(PS.PAYMENT_SCHEDULE_ID, -1, NULL, PS.DUE_DATE), ';

Line 1331: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);

1327: -- End - Bug#5358461 - Andre Araujo - 07/07/06 - We should ignore where payment schedule id is -1
1328:
1329: -- End fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1330:
1331: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1332:
1333:
1334: -- Open ref cursor for the query
1335: OPEN cv FOR l_data_query USING l_account, l_site, l_org, l_currency, l_partyid;

Line 1339: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);

1335: OPEN cv FOR l_data_query USING l_account, l_site, l_org, l_currency, l_partyid;
1336: FETCH cv INTO l_pay_date,l_receipt,l_PSDueDate,l_amount,l_currency,l_paynumber,l_status;
1337: CLOSE cv;
1338:
1339: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1340:
1341: x_last_pmt_info_rec.receipt_date := l_pay_date;
1342: x_last_pmt_info_rec.cash_receipt_id:= l_receipt;
1343: x_last_pmt_info_rec.due_date := l_PSDueDate;

Line 1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');

1363: -- endfix - bug #5665646- ehuh -2/27/2007-remove duplicate code
1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);

Line 1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);

1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);

Line 1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);

1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1373: END ;

Line 1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);

1366: WHEN OTHERS THEN
1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1373: END ;
1374: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance

Line 1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);

1367: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1373: END ;
1374: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1375:

Line 1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);

1368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1371: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Result: ' || l_pay_date || ':: ' || l_receipt || ':: ' || l_PSDueDate || ':: ' || l_amount || ':: ' || l_currency || ':: ' || l_paynumber || ':: ' || l_status);
1372: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1373: END ;
1374: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1375:
1376: /* --Begin - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance -- Removed code replaced with the one above

Line 1596: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

1592: END IF;
1593: -- End fix bug #4930425-jypark-01/10/2006-change query to remove full table scan
1594: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance -- Remoed code replaced with the one above*/
1595:
1596: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1597: END Get_Last_Payment_Info;
1598:
1599: PROCEDURE Get_Last_OKL_Payment_Info
1600: (p_api_version IN NUMBER := 1.0,

Line 1621: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

1617: TYPE c_last_pmt_cur_type IS REF CURSOR;
1618: c_last_pmt c_last_pmt_cur_type;
1619:
1620: BEGIN
1621: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1622:
1623: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
1624: -- IF p_object_type = 'CUSTOMER' AND p_object_id IS NOT NULL THEN
1625: -- OPEN c_last_pmt FOR

Line 1728: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

1724: --
1725: -- END IF;
1726: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
1727:
1728: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1729:
1730: END Get_Last_OKL_Payment_Info;
1731:
1732: PROCEDURE get_contact_point_info(p_api_version IN NUMBER := 1.0,

Line 1763: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

1759: l_contact_point_row c_contact_point%ROWTYPE;
1760: l_email_found VARCHAR2(1);
1761: l_phone_found VARCHAR2(1);
1762: BEGIN
1763: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1764: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id =' || p_party_id);
1765:
1766: l_email_found := 'N';
1767: l_phone_found := 'N';

Line 1764: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id =' || p_party_id);

1760: l_email_found VARCHAR2(1);
1761: l_phone_found VARCHAR2(1);
1762: BEGIN
1763: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1764: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id =' || p_party_id);
1765:
1766: l_email_found := 'N';
1767: l_phone_found := 'N';
1768:

Line 1795: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

1791: END LOOP;
1792:
1793: CLOSE c_contact_point;
1794:
1795: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1796: END get_contact_point_Info;
1797:
1798: PROCEDURE get_location_Info(
1799: p_api_version IN NUMBER := 1.0,

Line 1822: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

1818: and primary_flag = x_primary_flag;
1819: l_location_row c_get_location%ROWTYPE;
1820: x_get_location_found boolean := false;
1821: BEGIN
1822: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1823: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id=' || p_party_id);
1824:
1825: open c_get_location(p_party_id, 'Y');
1826: fetch c_get_location into l_location_row;

Line 1823: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id=' || p_party_id);

1819: l_location_row c_get_location%ROWTYPE;
1820: x_get_location_found boolean := false;
1821: BEGIN
1822: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1823: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id=' || p_party_id);
1824:
1825: open c_get_location(p_party_id, 'Y');
1826: fetch c_get_location into l_location_row;
1827: IF c_get_location%FOUND THEN

Line 1829: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':found location_row');

1825: open c_get_location(p_party_id, 'Y');
1826: fetch c_get_location into l_location_row;
1827: IF c_get_location%FOUND THEN
1828:
1829: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':found location_row');
1830:
1831: x_location_info_rec.location_id := l_location_row.location_id;
1832: x_location_info_rec.address2 := l_location_row.address2;
1833: x_location_info_rec.address3 := l_location_row.address3;

Line 1871: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

1867: x_location_info_rec.application_id := l_location_row.application_id;
1868:
1869: END IF;
1870: close c_get_location;
1871: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1872: END get_location_Info;
1873:
1874: PROCEDURE Get_Customer_Summary
1875: (p_api_version IN NUMBER := 1.0,

Line 2095: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

2091:
2092: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
2093:
2094: BEGIN
2095: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2096:
2097: --start moac change
2098: --to check whether all the ou's has the same functional currency or not
2099: l_cnt_cur_codes:= iex_currency_pvt.get_currency_count;

Line 2218: iex_debug_pub.LogMessage('3. l_delinquency_status :' || l_delinquency_status);

2214:
2215: IF l_status_rule_id IS NOT NULL THEN
2216: FOR r_rule IN c_rule LOOP
2217: l_delinquency_status := r_rule.delinquency_status;
2218: iex_debug_pub.LogMessage('3. l_delinquency_status :' || l_delinquency_status);
2219: IF l_delinquency_status = 'BANKRUPTCY' THEN
2220: l_sql_stmt := 'SELECT count(1)' ||
2221: ' FROM iex_bankruptcies' ||
2222: ' WHERE party_id = :party_id' ||

Line 2308: iex_debug_pub.LogMessage('3. p_party_id :' || p_party_id);

2304: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2305: ' AND status = ''PREDELINQUENT''';
2306: END IF;
2307:
2308: iex_debug_pub.LogMessage('3. p_party_id :' || p_party_id);
2309: /*
2310: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2311: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2312: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;

Line 2311: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);

2307:
2308: iex_debug_pub.LogMessage('3. p_party_id :' || p_party_id);
2309: /*
2310: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2311: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2312: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2313: ELSE
2314: */
2315: iex_debug_pub.LogMessage('3. l_sql_stmt :' || l_sql_stmt);

Line 2315: iex_debug_pub.LogMessage('3. l_sql_stmt :' || l_sql_stmt);

2311: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2312: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2313: ELSE
2314: */
2315: iex_debug_pub.LogMessage('3. l_sql_stmt :' || l_sql_stmt);
2316: OPEN c_del FOR l_sql_stmt USING p_party_id;
2317: --END IF;
2318: --End bug 9861733 gnramasa 19th July 2010
2319: FETCH c_del INTO l_count;

Line 2345: iex_debug_pub.LogMessage('4. l_delinquency_status :' || l_delinquency_status);

2341:
2342: IF l_status_rule_id IS NOT NULL THEN
2343: FOR r_rule IN c_rule LOOP
2344: l_delinquency_status := r_rule.delinquency_status;
2345: iex_debug_pub.LogMessage('4. l_delinquency_status :' || l_delinquency_status);
2346: IF l_delinquency_status = 'BANKRUPTCY' THEN
2347: l_sql_stmt := 'SELECT count(1)' ||
2348: ' FROM iex_bankruptcies' ||
2349: ' WHERE party_id = :party_id' ||

Line 2435: iex_debug_pub.LogMessage('4. p_party_id :' || p_party_id);

2431: ' WHERE party_cust_id = :party_id' ||
2432: ' AND status = ''PREDELINQUENT''';
2433: END IF;
2434:
2435: iex_debug_pub.LogMessage('4. p_party_id :' || p_party_id);
2436: /*
2437: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2438: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2439: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;

Line 2438: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);

2434:
2435: iex_debug_pub.LogMessage('4. p_party_id :' || p_party_id);
2436: /*
2437: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2438: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2439: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2440: ELSE
2441: */
2442: iex_debug_pub.LogMessage('4. l_sql_stmt :' || l_sql_stmt);

Line 2442: iex_debug_pub.LogMessage('4. l_sql_stmt :' || l_sql_stmt);

2438: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2439: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2440: ELSE
2441: */
2442: iex_debug_pub.LogMessage('4. l_sql_stmt :' || l_sql_stmt);
2443: OPEN c_del FOR l_sql_stmt USING p_party_id;
2444: --END IF;
2445: --End bug 9861733 gnramasa 19th July 2010
2446: -- End bug 6723556 gnramasa 10th Jan 2008

Line 2514: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

2510:
2511: x_object_info_rec.amount_overdue_curr := x_object_info_rec.current_balance_curr;
2512:
2513:
2514: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
2515: END Get_Customer_Summary;
2516:
2517: PROCEDURE Get_header_info
2518: (p_api_version IN NUMBER := 1.0,

Line 2547: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

2543: l_msg_data VARCHAR2(32767);
2544:
2545: l_party_id NUMBER;
2546: BEGIN
2547: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2548:
2549: SAVEPOINT Get_Header_Info_PVT;
2550:
2551: -- Standard call to check for call compatibility.

Line 2567: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_type=' || p_party_type || ':p_org_party_id' || p_org_party_id

2563:
2564: x_return_status := FND_API.G_RET_STS_SUCCESS;
2565:
2566:
2567: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_type=' || p_party_type || ':p_org_party_id' || p_org_party_id
2568: || ':p_person_paryt_id=' || p_person_party_id || ':p_rel_party_id=' || p_rel_party_id);
2569: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id || ':p_object_source=' || p_object_source);
2570:
2571: IF p_party_type in ('ORGANIZATION', 'RELATIONSHIP') THEN

Line 2569: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id || ':p_object_source=' || p_object_source);

2565:
2566:
2567: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_type=' || p_party_type || ':p_org_party_id' || p_org_party_id
2568: || ':p_person_paryt_id=' || p_person_party_id || ':p_rel_party_id=' || p_rel_party_id);
2569: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id || ':p_object_source=' || p_object_source);
2570:
2571: IF p_party_type in ('ORGANIZATION', 'RELATIONSHIP') THEN
2572: l_party_id := p_org_party_id;
2573: ELSE

Line 2658: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

2654: -- Standard call to get message count and if count is 1, get message info
2655: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2656:
2657:
2658: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
2659: EXCEPTION
2660: WHEN FND_API.G_EXC_ERROR THEN
2661: ROLLBACK TO Get_Header_Info_PVT;
2662: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2794: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');

2790: where party_id = p_partyid
2791: AND location_id = p_location_id;
2792:
2793: BEGIN
2794: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2795:
2796: SAVEPOINT Create_Default_Contact_PVT;
2797:
2798: -- Standard call to check for call compatibility.

Line 2825: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_org_party_id=' || p_org_party_id || ':p_person_party_id=' || p_person_party_id

2821: l_rel_object_version_number := 1.0;
2822: l_party_object_version_number := 1.0;
2823: l_object_version_number := 1.0;
2824:
2825: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_org_party_id=' || p_org_party_id || ':p_person_party_id=' || p_person_party_id
2826: || ':p_phone_contact_point_id=' || p_phone_contact_point_id || ':p_type=' || p_type);
2827:
2828: l_party_id := p_org_party_id;
2829:

Line 2831: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_relationship_id=' || r_exist_rel.relationship_id);

2827:
2828: l_party_id := p_org_party_id;
2829:
2830: FOR r_exist_rel IN c_exist_rel LOOP
2831: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_relationship_id=' || r_exist_rel.relationship_id);
2832:
2833: l_party_rel_update_rec.relationship_id := r_exist_rel.relationship_id;
2834: l_party_rel_update_rec.subject_id := r_exist_rel.subject_id;
2835: l_party_rel_update_rec.object_id := r_exist_rel.object_id;

Line 2863: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact...');

2859: OPEN c_party(r_exist_rel.party_id);
2860: FETCH c_party INTO l_party_object_version_number;
2861: CLOSE c_party;
2862:
2863: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact...');
2864:
2865: HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact(
2866: p_init_msg_list => 'F',
2867: p_org_contact_rec => l_org_contact_update_rec,

Line 2875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);

2871: p_cont_object_version_number => l_cont_object_version_number,
2872: p_rel_object_version_number => l_rel_object_version_number,
2873: p_party_object_version_number => l_party_object_version_number);
2874:
2875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2876: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2877: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2878: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2879:

Line 2876: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);

2872: p_rel_object_version_number => l_rel_object_version_number,
2873: p_party_object_version_number => l_party_object_version_number);
2874:
2875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2876: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2877: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2878: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2879:
2880: IF l_return_status = FND_API.G_RET_STS_ERROR OR

Line 2877: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);

2873: p_party_object_version_number => l_party_object_version_number);
2874:
2875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2876: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2877: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2878: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2879:
2880: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2881: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2878: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);

2874:
2875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2876: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2877: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2878: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2879:
2880: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2881: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2882: RAISE FND_API.G_EXC_ERROR;

Line 2910: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));

2906: --set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2907:
2908: l_party_rel_create_rec.application_id := 625;
2909:
2910: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2911:
2912: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2913: SELECT hz_parties_s.nextval
2914: INTO l_party_rel_create_rec.party_rec.party_number

Line 2940: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Create_Org_Contact...');

2936: --set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2937:
2938: l_org_contact_create_rec.application_id := 625;
2939:
2940: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Create_Org_Contact...');
2941:
2942: HZ_PARTY_CONTACT_V2PUB.Create_Org_Contact(
2943: p_init_msg_list => 'F',
2944: p_org_contact_rec => l_org_contact_create_rec,

Line 2953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);

2949: x_party_rel_id => l_party_relationship_id,
2950: x_party_id => l_party_id,
2951: x_party_number => l_party_number );
2952:
2953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2954: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_org_contact_id=' || l_org_contact_id || ' l_party_id=' || l_party_id || ' l_party_number=' || l_party_number);
2955: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2956:
2957: x_party_id := l_party_id;

Line 2954: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_org_contact_id=' || l_org_contact_id || ' l_party_id=' || l_party_id || ' l_party_number=' || l_party_number);

2950: x_party_id => l_party_id,
2951: x_party_number => l_party_number );
2952:
2953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2954: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_org_contact_id=' || l_org_contact_id || ' l_party_id=' || l_party_id || ' l_party_number=' || l_party_number);
2955: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2956:
2957: x_party_id := l_party_id;
2958: x_relationship_id := l_party_relationship_id;

Line 2955: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);

2951: x_party_number => l_party_number );
2952:
2953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2954: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_org_contact_id=' || l_org_contact_id || ' l_party_id=' || l_party_id || ' l_party_number=' || l_party_number);
2955: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2956:
2957: x_party_id := l_party_id;
2958: x_relationship_id := l_party_relationship_id;
2959:

Line 2975: iex_debug_pub.LogMessage('l_phone_rec.contact_point_id:' || l_phone_rec.contact_point_id);

2971: OPEN c_phone_contact_point(p_phone_contact_point_id);
2972: LOOP
2973: FETCH c_phone_contact_point INTO l_phone_rec;
2974: EXIT WHEN c_phone_contact_point%NOTFOUND;
2975: iex_debug_pub.LogMessage('l_phone_rec.contact_point_id:' || l_phone_rec.contact_point_id);
2976: iex_debug_pub.LogMessage('l_phone_rec.owner_table_id:' || l_contact_point_create_rec.owner_table_id);
2977: --End Bug 6509624 31-Mar-2009 barathsr
2978: l_contact_point_create_rec.contact_point_type := l_phone_rec.contact_point_type;
2979: l_contact_point_create_rec.status := l_phone_rec.status;

Line 2976: iex_debug_pub.LogMessage('l_phone_rec.owner_table_id:' || l_contact_point_create_rec.owner_table_id);

2972: LOOP
2973: FETCH c_phone_contact_point INTO l_phone_rec;
2974: EXIT WHEN c_phone_contact_point%NOTFOUND;
2975: iex_debug_pub.LogMessage('l_phone_rec.contact_point_id:' || l_phone_rec.contact_point_id);
2976: iex_debug_pub.LogMessage('l_phone_rec.owner_table_id:' || l_contact_point_create_rec.owner_table_id);
2977: --End Bug 6509624 31-Mar-2009 barathsr
2978: l_contact_point_create_rec.contact_point_type := l_phone_rec.contact_point_type;
2979: l_contact_point_create_rec.status := l_phone_rec.status;
2980: l_contact_point_create_rec.owner_table_name := l_phone_rec.owner_table_name;

Line 3028: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_phone_contact_point ...');

3024: l_phone_create_rec.phone_extension := l_phone_rec.phone_extension;
3025: l_phone_create_rec.phone_line_type := l_phone_rec.phone_line_type;
3026: --l_phone_create_rec.raw_phone_number := l_phone_rec.raw_phone_number;
3027:
3028: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_phone_contact_point ...');
3029:
3030: hz_contact_point_v2pub.create_phone_contact_point(
3031: p_init_msg_list => 'F',
3032: x_return_status => l_return_status,

Line 3039: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);

3035: p_contact_point_rec => l_contact_point_create_rec,
3036: p_phone_rec => l_phone_create_rec,
3037: x_contact_point_id => l_contact_point_id);
3038:
3039: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);
3040:
3041: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3042: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;

Line 3100: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_email_contact_point ...');

3096:
3097: l_email_create_rec.email_format := l_email_rec.email_format;
3098: l_email_create_rec.email_address := l_email_rec.email_address;
3099:
3100: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_email_contact_point ...');
3101:
3102: hz_contact_point_v2pub.create_email_contact_point(
3103: p_init_msg_list => 'F',
3104: x_return_status => l_return_status,

Line 3111: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);

3107: p_contact_point_rec => l_contact_point_create_rec,
3108: p_email_rec => l_email_create_rec,
3109: x_contact_point_id => l_contact_point_id);
3110:
3111: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);
3112:
3113: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3114: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_ERROR;

Line 3129: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting location ID...l_party_id ==> '||l_party_id);

3125: where identifying_address_flag = 'Y'
3126: and party_id = p_org_party_id;
3127: exception
3128: when others then
3129: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting location ID...l_party_id ==> '||l_party_id);
3130: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3131: RAISE FND_API.G_EXC_ERROR;
3132: end;
3133: */

Line 3130: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);

3126: and party_id = p_org_party_id;
3127: exception
3128: when others then
3129: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting location ID...l_party_id ==> '||l_party_id);
3130: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3131: RAISE FND_API.G_EXC_ERROR;
3132: end;
3133: */
3134: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Location Id => '||l_location_id);

Line 3134: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Location Id => '||l_location_id);

3130: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3131: RAISE FND_API.G_EXC_ERROR;
3132: end;
3133: */
3134: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Location Id => '||l_location_id);
3135: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id => '||l_party_site_id);
3136:
3137: begin
3138:

Line 3135: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id => '||l_party_site_id);

3131: RAISE FND_API.G_EXC_ERROR;
3132: end;
3133: */
3134: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Location Id => '||l_location_id);
3135: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id => '||l_party_site_id);
3136:
3137: begin
3138:
3139: /*

Line 3175: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...l_party_site_id ==> '||l_party_site_id);

3171: commit;
3172:
3173: exception
3174: when others then
3175: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...l_party_site_id ==> '||l_party_site_id);
3176: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...t_cust_account_id ==> '||t_cust_account_id);
3177: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3178: RAISE FND_API.G_EXC_ERROR;
3179: end;

Line 3176: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...t_cust_account_id ==> '||t_cust_account_id);

3172:
3173: exception
3174: when others then
3175: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...l_party_site_id ==> '||l_party_site_id);
3176: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...t_cust_account_id ==> '||t_cust_account_id);
3177: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3178: RAISE FND_API.G_EXC_ERROR;
3179: end;
3180: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'From getting CUST_ACCT_SITE_ID...l_cust_acct_site_id ==> '||l_cust_acct_site_id);

Line 3177: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);

3173: exception
3174: when others then
3175: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...l_party_site_id ==> '||l_party_site_id);
3176: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...t_cust_account_id ==> '||t_cust_account_id);
3177: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3178: RAISE FND_API.G_EXC_ERROR;
3179: end;
3180: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'From getting CUST_ACCT_SITE_ID...l_cust_acct_site_id ==> '||l_cust_acct_site_id);
3181: -- end ER 13329879

Line 3180: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'From getting CUST_ACCT_SITE_ID...l_cust_acct_site_id ==> '||l_cust_acct_site_id);

3176: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Exception from getting CUST_ACCT_SITE_ID...t_cust_account_id ==> '||t_cust_account_id);
3177: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Error Code / Msg => '||sqlerrm);
3178: RAISE FND_API.G_EXC_ERROR;
3179: end;
3180: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'From getting CUST_ACCT_SITE_ID...l_cust_acct_site_id ==> '||l_cust_acct_site_id);
3181: -- end ER 13329879
3182:
3183: IF l_location_id IS NOT NULL THEN
3184:

Line 3185: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id || ':l_location_id=' || l_location_id);

3181: -- end ER 13329879
3182:
3183: IF l_location_id IS NOT NULL THEN
3184:
3185: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id || ':l_location_id=' || l_location_id);
3186: OPEN c_CheckPartySite(l_party_id, l_location_id);
3187: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
3188:
3189: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id(2) => '||l_party_site_id);

Line 3189: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id(2) => '||l_party_site_id);

3185: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id || ':l_location_id=' || l_location_id);
3186: OPEN c_CheckPartySite(l_party_id, l_location_id);
3187: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
3188:
3189: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id(2) => '||l_party_site_id);
3190: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Number => '||l_party_site_number);
3191:
3192: IF (c_CheckPartySite%FOUND) THEN
3193: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');

Line 3190: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Number => '||l_party_site_number);

3186: OPEN c_CheckPartySite(l_party_id, l_location_id);
3187: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
3188:
3189: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id(2) => '||l_party_site_id);
3190: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Number => '||l_party_site_number);
3191:
3192: IF (c_CheckPartySite%FOUND) THEN
3193: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');
3194: l_call_api := FALSE;

Line 3193: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');

3189: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Id(2) => '||l_party_site_id);
3190: iex_debug_pub.logmessage(G_PKG_NAME || '.' || l_api_name ||'Party Site Number => '||l_party_site_number);
3191:
3192: IF (c_CheckPartySite%FOUND) THEN
3193: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');
3194: l_call_api := FALSE;
3195: ELSE
3196: l_call_api := TRUE;
3197: END IF; /*End of C_CheckPartySite%FOUND if loop */

Line 3204: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));

3200: IF l_Call_Api then
3201: l_Party_Site_Create_rec.Party_Id := l_party_id;
3202: l_Party_Site_Create_rec.Location_Id := l_location_id;
3203:
3204: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
3205:
3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number

Line 3210: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);

3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number
3209: FROM dual;
3210: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
3211: ELSE
3212: l_Party_Site_Create_rec.Party_Site_Number := NULL;
3213: END IF;
3214:

Line 3238: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);

3234: x_party_site_id => l_party_site_id,
3235: x_party_site_number => l_party_site_number
3236: );
3237:
3238: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3239: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
3240: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3241:
3242: IF l_return_status = FND_API.G_RET_STS_ERROR OR

Line 3239: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);

3235: x_party_site_number => l_party_site_number
3236: );
3237:
3238: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3239: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
3240: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3241:
3242: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3243: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3240: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);

3236: );
3237:
3238: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3239: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
3240: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3241:
3242: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3243: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;

Line 3274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);

3270: x_return_status => l_return_status,
3271: x_msg_count => l_msg_count,
3272: x_msg_data => l_msg_data);
3273:
3274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3275: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cust_account_role_id=' || l_cust_account_role_id);
3276:
3277: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3278: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3275: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cust_account_role_id=' || l_cust_account_role_id);

3271: x_msg_count => l_msg_count,
3272: x_msg_data => l_msg_data);
3273:
3274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
3275: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cust_account_role_id=' || l_cust_account_role_id);
3276:
3277: IF l_return_status = FND_API.G_RET_STS_ERROR OR
3278: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_ERROR;

Line 3292: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');

3288: -- Standard call to get message count and if count is 1, get message info
3289: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3290:
3291:
3292: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
3293: EXCEPTION
3294: WHEN FND_API.G_EXC_ERROR THEN
3295: ROLLBACK TO Create_Default_Contact_PVT;
3296: x_return_status := FND_API.G_RET_STS_ERROR;