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 289: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);

285: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
286: ' AND status = ''PREDELINQUENT''';
287: END IF;
288:
289: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);
290: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
291: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
292: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
293: ELSE

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

287: END IF;
288:
289: iex_debug_pub.LogMessage('1. p_party_id :' || p_party_id);
290: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
291: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
292: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
293: ELSE
294: iex_debug_pub.LogMessage('1. l_sql_stmt :' || l_sql_stmt);
295: OPEN c_del FOR l_sql_stmt USING p_party_id;

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

290: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
291: iex_debug_pub.LogMessage('1. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
292: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
293: ELSE
294: iex_debug_pub.LogMessage('1. l_sql_stmt :' || l_sql_stmt);
295: OPEN c_del FOR l_sql_stmt USING p_party_id;
296: END IF;
297: FETCH c_del INTO l_count;
298:

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

319:
320: IF l_status_rule_id IS NOT NULL THEN
321: FOR r_rule IN c_rule LOOP
322: l_delinquency_status := r_rule.delinquency_status;
323: iex_debug_pub.LogMessage('2. l_delinquency_status :' || l_delinquency_status);
324: IF l_delinquency_status = 'BANKRUPTCY' THEN
325: l_sql_stmt := 'SELECT count(1)' ||
326: ' FROM iex_bankruptcies' ||
327: ' WHERE party_id = :party_id' ||

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

389: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
390: ' AND status = ''PREDELINQUENT''';
391: END IF;
392:
393: iex_debug_pub.LogMessage('2. p_party_id :' || p_party_id);
394: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
395: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
396: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
397: ELSE

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

391: END IF;
392:
393: iex_debug_pub.LogMessage('2. p_party_id :' || p_party_id);
394: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
395: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
396: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
397: ELSE
398: iex_debug_pub.LogMessage('2. l_sql_stmt :' || l_sql_stmt);
399: OPEN c_del FOR l_sql_stmt USING p_party_id;

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

394: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
395: iex_debug_pub.LogMessage('2. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
396: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
397: ELSE
398: iex_debug_pub.LogMessage('2. l_sql_stmt :' || l_sql_stmt);
399: OPEN c_del FOR l_sql_stmt USING p_party_id;
400: END IF;
401: --End bug 6723556 gnramasa 10th Jan 2008
402: FETCH c_del INTO l_count;

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

424: END IF;
425: END IF;
426:
427: -- End for bug#7830847
428: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
429: END Get_Customer_Info;
430:
431: PROCEDURE Get_Customer_OKL_Info
432: (p_api_version IN NUMBER := 1.0,

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

472: -- and del.status = 'DELINQUENT';
473: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
474:
475: BEGIN
476: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
477:
478: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
479: -- OPEN c_del_cases;
480: -- FETCH c_del_cases INTO x_customer_okl_info_rec.CASES_OVERDUE;

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

488: -- FETCH c_del_cases_past_year INTO x_customer_okl_info_rec.NUMBER_OF_DEL_CASES;
489: -- CLOSE c_del_cases_past_year;
490: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
491:
492: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
493: END Get_Customer_OKL_Info;
494:
495: PROCEDURE Get_Object_Info
496: (p_api_version IN NUMBER := 1.0,

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

539:
540: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
541:
542: BEGIN
543: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
544: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||
545: ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id);
546:
547: --start moac change

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

540: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
541:
542: BEGIN
543: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
544: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||
545: ':p_object_type=' || p_object_type || ':p_object_id=' || p_object_id);
546:
547: --start moac change
548: --to check whether all the ou's has the same functional currency or not

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

1015: end if; --end if for check on count of currency codes(moac change).
1016:
1017: x_object_info_rec.amount_overdue_curr := x_object_info_rec.current_balance_curr;
1018:
1019: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1020:
1021: END Get_Object_Info;
1022:
1023: PROCEDURE Get_Last_Payment_Info

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

1078: l_show_last_pmt_due VARCHAR2(240);
1079: --End-fix bug #5407151-JYPARK-08012006-hide last payment due on depending on profile IEX_SHOW_LAST_PMT_DUE
1080:
1081: BEGIN
1082: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1083:
1084: --Begin - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1085: --First we will find the PK for the record with the info we want
1086: BEGIN

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

1145: END IF;
1146:
1147: l_pk_query := l_pk_query || l_pk_from || l_pk_where || l_pk_group;
1148:
1149: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1150:
1151: -- Open ref cursor for the query
1152: OPEN cv FOR l_pk_query USING p_object_id;
1153: FETCH cv INTO l_partyid, l_account, l_site, l_org, l_currency, l_pay_date;

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

1152: OPEN cv FOR l_pk_query USING p_object_id;
1153: FETCH cv INTO l_partyid, l_account, l_site, l_org, l_currency, l_pay_date;
1154: CLOSE cv;
1155:
1156: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1157:
1158: -- Now we have the primary key to our info, get the data
1159:
1160: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');

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

1156: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1157:
1158: -- Now we have the primary key to our info, get the data
1159:
1160: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1161:
1162: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1163: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1164: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);

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

1160: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1161:
1162: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1163: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1164: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);
1165:
1166: IF l_show_last_pmt_due = 'Y' THEN
1167: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';
1168: l_data_query := l_data_query || ' DECODE(PS.PAYMENT_SCHEDULE_ID, -1, NULL, PS.DUE_DATE), ';

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

1212: -- End - Bug#5358461 - Andre Araujo - 07/07/06 - We should ignore where payment schedule id is -1
1213:
1214: -- End fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1215:
1216: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1217:
1218:
1219: -- Open ref cursor for the query
1220: OPEN cv FOR l_data_query USING l_account, l_site, l_org, l_currency, l_partyid;

Line 1224: 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);

1220: OPEN cv FOR l_data_query USING l_account, l_site, l_org, l_currency, l_partyid;
1221: FETCH cv INTO l_pay_date,l_receipt,l_PSDueDate,l_amount,l_currency,l_paynumber,l_status;
1222: CLOSE cv;
1223:
1224: 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);
1225:
1226: x_last_pmt_info_rec.receipt_date := l_pay_date;
1227: x_last_pmt_info_rec.cash_receipt_id:= l_receipt;
1228: x_last_pmt_info_rec.due_date := l_PSDueDate;

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

1248: -- endfix - bug #5665646- ehuh -2/27/2007-remove duplicate code
1249:
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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 1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);

1249:
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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);
1257: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);

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

1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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);
1257: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1258: END ;

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

1251: WHEN OTHERS THEN
1252: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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);
1257: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1258: END ;
1259: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance

Line 1256: 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);

1252: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':EXCEPTION!!!!!');
1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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);
1257: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1258: END ;
1259: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1260:

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

1253: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: ' || l_pk_query);
1254: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Result: ' || l_account || ':: ' || l_site || ':: ' || l_org || ':: ' || l_currency || ':: ' || l_pay_date);
1255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Data Query: ' || l_data_query);
1256: 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);
1257: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || SQLCODE || SQLERRM);
1258: END ;
1259: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance
1260:
1261: /* --Begin - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance -- Removed code replaced with the one above

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

1477: END IF;
1478: -- End fix bug #4930425-jypark-01/10/2006-change query to remove full table scan
1479: --End - Andre Araujo - 03/13/06 - Bug#5024219 - Improving performance -- Remoed code replaced with the one above*/
1480:
1481: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1482: END Get_Last_Payment_Info;
1483:
1484: PROCEDURE Get_Last_OKL_Payment_Info
1485: (p_api_version IN NUMBER := 1.0,

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

1502: TYPE c_last_pmt_cur_type IS REF CURSOR;
1503: c_last_pmt c_last_pmt_cur_type;
1504:
1505: BEGIN
1506: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1507:
1508: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
1509: -- IF p_object_type = 'CUSTOMER' AND p_object_id IS NOT NULL THEN
1510: -- OPEN c_last_pmt FOR

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

1609: --
1610: -- END IF;
1611: -- End fix bug #4930425-jypark-01/10/2006-removed obsolete query
1612:
1613: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1614:
1615: END Get_Last_OKL_Payment_Info;
1616:
1617: PROCEDURE get_contact_point_info(p_api_version IN NUMBER := 1.0,

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

1644: l_contact_point_row c_contact_point%ROWTYPE;
1645: l_email_found VARCHAR2(1);
1646: l_phone_found VARCHAR2(1);
1647: BEGIN
1648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id =' || p_party_id);
1650:
1651: l_email_found := 'N';
1652: l_phone_found := 'N';

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

1645: l_email_found VARCHAR2(1);
1646: l_phone_found VARCHAR2(1);
1647: BEGIN
1648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id =' || p_party_id);
1650:
1651: l_email_found := 'N';
1652: l_phone_found := 'N';
1653:

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

1676: END LOOP;
1677:
1678: CLOSE c_contact_point;
1679:
1680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1681: END get_contact_point_Info;
1682:
1683: PROCEDURE get_location_Info(
1684: p_api_version IN NUMBER := 1.0,

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

1703: and primary_flag = x_primary_flag;
1704: l_location_row c_get_location%ROWTYPE;
1705: x_get_location_found boolean := false;
1706: BEGIN
1707: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1708: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id=' || p_party_id);
1709:
1710: open c_get_location(p_party_id, 'Y');
1711: fetch c_get_location into l_location_row;

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

1704: l_location_row c_get_location%ROWTYPE;
1705: x_get_location_found boolean := false;
1706: BEGIN
1707: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1708: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_id=' || p_party_id);
1709:
1710: open c_get_location(p_party_id, 'Y');
1711: fetch c_get_location into l_location_row;
1712: IF c_get_location%FOUND THEN

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

1710: open c_get_location(p_party_id, 'Y');
1711: fetch c_get_location into l_location_row;
1712: IF c_get_location%FOUND THEN
1713:
1714: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':found location_row');
1715:
1716: x_location_info_rec.location_id := l_location_row.location_id;
1717: x_location_info_rec.address2 := l_location_row.address2;
1718: x_location_info_rec.address3 := l_location_row.address3;

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

1752: x_location_info_rec.application_id := l_location_row.application_id;
1753:
1754: END IF;
1755: close c_get_location;
1756: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
1757: END get_location_Info;
1758:
1759: PROCEDURE Get_Customer_Summary
1760: (p_api_version IN NUMBER := 1.0,

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

1959:
1960: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
1961:
1962: BEGIN
1963: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1964:
1965: --start moac change
1966: --to check whether all the ou's has the same functional currency or not
1967: l_cnt_cur_codes:= iex_currency_pvt.get_currency_count;

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

2073:
2074: IF l_status_rule_id IS NOT NULL THEN
2075: FOR r_rule IN c_rule LOOP
2076: l_delinquency_status := r_rule.delinquency_status;
2077: iex_debug_pub.LogMessage('3. l_delinquency_status :' || l_delinquency_status);
2078: IF l_delinquency_status = 'BANKRUPTCY' THEN
2079: l_sql_stmt := 'SELECT count(1)' ||
2080: ' FROM iex_bankruptcies' ||
2081: ' WHERE party_id = :party_id' ||

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

2143: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2144: ' AND status = ''PREDELINQUENT''';
2145: END IF;
2146:
2147: iex_debug_pub.LogMessage('3. p_party_id :' || p_party_id);
2148: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2149: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2150: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2151: ELSE

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

2145: END IF;
2146:
2147: iex_debug_pub.LogMessage('3. p_party_id :' || p_party_id);
2148: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2149: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2150: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2151: ELSE
2152: iex_debug_pub.LogMessage('3. l_sql_stmt :' || l_sql_stmt);
2153: OPEN c_del FOR l_sql_stmt USING p_party_id;

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

2148: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2149: iex_debug_pub.LogMessage('3. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2150: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2151: ELSE
2152: iex_debug_pub.LogMessage('3. l_sql_stmt :' || l_sql_stmt);
2153: OPEN c_del FOR l_sql_stmt USING p_party_id;
2154: END IF;
2155: FETCH c_del INTO l_count;
2156:

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

2177:
2178: IF l_status_rule_id IS NOT NULL THEN
2179: FOR r_rule IN c_rule LOOP
2180: l_delinquency_status := r_rule.delinquency_status;
2181: iex_debug_pub.LogMessage('4. l_delinquency_status :' || l_delinquency_status);
2182: IF l_delinquency_status = 'BANKRUPTCY' THEN
2183: l_sql_stmt := 'SELECT count(1)' ||
2184: ' FROM iex_bankruptcies' ||
2185: ' WHERE party_id = :party_id' ||

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

2247: ' WHERE party_cust_id = :party_id' ||
2248: ' AND status = ''PREDELINQUENT''';
2249: END IF;
2250:
2251: iex_debug_pub.LogMessage('4. p_party_id :' || p_party_id);
2252: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2253: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2254: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2255: ELSE

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

2249: END IF;
2250:
2251: iex_debug_pub.LogMessage('4. p_party_id :' || p_party_id);
2252: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2253: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2254: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2255: ELSE
2256: iex_debug_pub.LogMessage('4. l_sql_stmt :' || l_sql_stmt);
2257: OPEN c_del FOR l_sql_stmt USING p_party_id;

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

2252: IF l_delinquency_status in ('LITIGATION','REPOSSESSION','WRITEOFF') THEN
2253: iex_debug_pub.LogMessage('4. l_sql_stmt_lsd :' || l_sql_stmt_lsd);
2254: OPEN c_del FOR l_sql_stmt_lsd USING p_party_id,p_party_id;
2255: ELSE
2256: iex_debug_pub.LogMessage('4. l_sql_stmt :' || l_sql_stmt);
2257: OPEN c_del FOR l_sql_stmt USING p_party_id;
2258: END IF;
2259: -- End bug 6723556 gnramasa 10th Jan 2008
2260: FETCH c_del INTO l_count;

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

2312:
2313: x_object_info_rec.amount_overdue_curr := x_object_info_rec.current_balance_curr;
2314:
2315:
2316: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
2317: END Get_Customer_Summary;
2318:
2319: PROCEDURE Get_header_info
2320: (p_api_version IN NUMBER := 1.0,

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

2345: l_msg_data VARCHAR2(32767);
2346:
2347: l_party_id NUMBER;
2348: BEGIN
2349: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2350:
2351: SAVEPOINT Get_Header_Info_PVT;
2352:
2353: -- Standard call to check for call compatibility.

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

2365:
2366: x_return_status := FND_API.G_RET_STS_SUCCESS;
2367:
2368:
2369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_type=' || p_party_type || ':p_org_party_id' || p_org_party_id
2370: || ':p_person_paryt_id=' || p_person_party_id || ':p_rel_party_id=' || p_rel_party_id);
2371: 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);
2372:
2373: IF p_party_type in ('ORGANIZATION', 'RELATIONSHIP') THEN

Line 2371: 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);

2367:
2368:
2369: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_party_type=' || p_party_type || ':p_org_party_id' || p_org_party_id
2370: || ':p_person_paryt_id=' || p_person_party_id || ':p_rel_party_id=' || p_rel_party_id);
2371: 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);
2372:
2373: IF p_party_type in ('ORGANIZATION', 'RELATIONSHIP') THEN
2374: l_party_id := p_org_party_id;
2375: ELSE

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

2456: -- Standard call to get message count and if count is 1, get message info
2457: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2458:
2459:
2460: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
2461: EXCEPTION
2462: WHEN FND_API.G_EXC_ERROR THEN
2463: ROLLBACK TO Get_Header_Info_PVT;
2464: x_return_status := FND_API.G_RET_STS_ERROR;

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

2563: where party_id = p_partyid
2564: AND location_id = p_location_id;
2565:
2566: BEGIN
2567: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2568:
2569: SAVEPOINT Create_Default_Contact_PVT;
2570:
2571: -- Standard call to check for call compatibility.

Line 2598: 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

2594: l_rel_object_version_number := 1.0;
2595: l_party_object_version_number := 1.0;
2596: l_object_version_number := 1.0;
2597:
2598: 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
2599: || ':p_phone_contact_point_id=' || p_phone_contact_point_id || ':p_type=' || p_type);
2600:
2601: l_party_id := p_org_party_id;
2602:

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

2600:
2601: l_party_id := p_org_party_id;
2602:
2603: FOR r_exist_rel IN c_exist_rel LOOP
2604: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_relationship_id=' || r_exist_rel.relationship_id);
2605:
2606: l_party_rel_update_rec.relationship_id := r_exist_rel.relationship_id;
2607: l_party_rel_update_rec.subject_id := r_exist_rel.subject_id;
2608: l_party_rel_update_rec.object_id := r_exist_rel.object_id;

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

2632: OPEN c_party(r_exist_rel.party_id);
2633: FETCH c_party INTO l_party_object_version_number;
2634: CLOSE c_party;
2635:
2636: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact...');
2637:
2638: HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact(
2639: p_init_msg_list => 'F',
2640: p_org_contact_rec => l_org_contact_update_rec,

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

2644: p_cont_object_version_number => l_cont_object_version_number,
2645: p_rel_object_version_number => l_rel_object_version_number,
2646: p_party_object_version_number => l_party_object_version_number);
2647:
2648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2650: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2651: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2652:

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

2645: p_rel_object_version_number => l_rel_object_version_number,
2646: p_party_object_version_number => l_party_object_version_number);
2647:
2648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2650: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2651: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2652:
2653: IF l_return_status = FND_API.G_RET_STS_ERROR OR

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

2646: p_party_object_version_number => l_party_object_version_number);
2647:
2648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2650: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2651: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2652:
2653: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2654: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2647:
2648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2649: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_cont_object_version_number=' || l_cont_object_version_number);
2650: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_rel_object_version_number=' || l_rel_object_version_number);
2651: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_object_version_number=' || l_party_object_version_number);
2652:
2653: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2654: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2655: RAISE FND_API.G_EXC_ERROR;

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

2676: END IF;
2677: --End-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections, set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2678: l_party_rel_create_rec.application_id := 625;
2679:
2680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2681:
2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2683: SELECT hz_parties_s.nextval
2684: INTO l_party_rel_create_rec.party_rec.party_number

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

2699: --End-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections, set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2700:
2701: l_org_contact_create_rec.application_id := 625;
2702:
2703: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling HZ_PARTY_CONTACT_V2PUB.Create_Org_Contact...');
2704:
2705: HZ_PARTY_CONTACT_V2PUB.Create_Org_Contact(
2706: p_init_msg_list => 'F',
2707: p_org_contact_rec => l_org_contact_create_rec,

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

2712: x_party_rel_id => l_party_relationship_id,
2713: x_party_id => l_party_id,
2714: x_party_number => l_party_number );
2715:
2716: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2717: 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);
2718: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2719:
2720: x_party_id := l_party_id;

Line 2717: 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);

2713: x_party_id => l_party_id,
2714: x_party_number => l_party_number );
2715:
2716: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2717: 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);
2718: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2719:
2720: x_party_id := l_party_id;
2721: x_relationship_id := l_party_relationship_id;

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

2714: x_party_number => l_party_number );
2715:
2716: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2717: 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);
2718: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id);
2719:
2720: x_party_id := l_party_id;
2721: x_relationship_id := l_party_relationship_id;
2722:

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

2776: l_phone_create_rec.phone_extension := l_phone_rec.phone_extension;
2777: l_phone_create_rec.phone_line_type := l_phone_rec.phone_line_type;
2778: --l_phone_create_rec.raw_phone_number := l_phone_rec.raw_phone_number;
2779:
2780: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_phone_contact_point ...');
2781:
2782: hz_contact_point_v2pub.create_phone_contact_point(
2783: p_init_msg_list => 'F',
2784: x_return_status => l_return_status,

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

2787: p_contact_point_rec => l_contact_point_create_rec,
2788: p_phone_rec => l_phone_create_rec,
2789: x_contact_point_id => l_contact_point_id);
2790:
2791: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);
2792:
2793: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2794: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2795: RAISE FND_API.G_EXC_ERROR;

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

2844:
2845: l_email_create_rec.email_format := l_email_rec.email_format;
2846: l_email_create_rec.email_address := l_email_rec.email_address;
2847:
2848: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':calling hz_contact_point_v2pub.create_email_contact_point ...');
2849:
2850: hz_contact_point_v2pub.create_email_contact_point(
2851: p_init_msg_list => 'F',
2852: x_return_status => l_return_status,

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

2855: p_contact_point_rec => l_contact_point_create_rec,
2856: p_email_rec => l_email_create_rec,
2857: x_contact_point_id => l_contact_point_id);
2858:
2859: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status || ':l_contact_point_id=' || l_contact_point_id);
2860:
2861: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2862: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;

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

2865:
2866: END IF; /* IF p_email_contact_point_id IS NOT NULL THEN */
2867:
2868: IF p_location_id IS NOT NULL THEN
2869: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id || ':p_location_id=' || p_location_id);
2870: OPEN c_CheckPartySite(l_party_id, p_location_id);
2871: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
2872:
2873: IF (c_CheckPartySite%FOUND) THEN

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

2870: OPEN c_CheckPartySite(l_party_id, p_location_id);
2871: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
2872:
2873: IF (c_CheckPartySite%FOUND) THEN
2874: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');
2875: l_call_api := FALSE;
2876: ELSE
2877: l_call_api := TRUE;
2878: END IF; /*End of C_CheckPartySite%FOUND if loop */

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

2881: IF l_Call_Api then
2882: l_Party_Site_Create_rec.Party_Id := l_party_id;
2883: l_Party_Site_Create_rec.Location_Id := p_location_id;
2884:
2885: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2886:
2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number

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

2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number
2890: FROM dual;
2891: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2892: ELSE
2893: l_Party_Site_Create_rec.Party_Site_Number := NULL;
2894: END IF;
2895:

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

2917: x_party_site_id => l_party_site_id,
2918: x_party_site_number => l_party_site_number
2919: );
2920:
2921: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2922: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
2923:
2924: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2925:

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

2918: x_party_site_number => l_party_site_number
2919: );
2920:
2921: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2922: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
2923:
2924: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2925:
2926: IF l_return_status = FND_API.G_RET_STS_ERROR OR

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

2920:
2921: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2922: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
2923:
2924: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2925:
2926: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2927: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2928: RAISE FND_API.G_EXC_ERROR;

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

2932:
2933: END IF; /* IF p_location_id IS NOT NULL THEN */
2934:
2935: IF p_location_id IS NOT NULL THEN
2936: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_id=' || l_party_id || ':p_location_id=' || p_location_id);
2937: OPEN c_CheckPartySite(l_party_id, p_location_id);
2938: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
2939:
2940: IF (c_CheckPartySite%FOUND) THEN

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

2937: OPEN c_CheckPartySite(l_party_id, p_location_id);
2938: FETCH c_CheckPartySite INTO l_party_site_id, l_party_site_number;
2939:
2940: IF (c_CheckPartySite%FOUND) THEN
2941: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':party site existing already');
2942: l_call_api := FALSE;
2943: ELSE
2944: l_call_api := TRUE;
2945: END IF; /*End of C_CheckPartySite%FOUND if loop */

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

2948: IF l_Call_Api then
2949: l_Party_Site_Create_rec.Party_Id := l_party_id;
2950: l_Party_Site_Create_rec.Location_Id := p_location_id;
2951:
2952: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2953:
2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number

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

2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number
2957: FROM dual;
2958: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2959: ELSE
2960: l_Party_Site_Create_rec.Party_Site_Number := NULL;
2961: END IF;
2962:

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

2984: x_party_site_id => l_party_site_id,
2985: x_party_site_number => l_party_site_number
2986: );
2987:
2988: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2989: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
2990:
2991: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2992: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2985: x_party_site_number => l_party_site_number
2986: );
2987:
2988: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_return_status=' || l_return_status);
2989: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_id=' || l_party_site_id);
2990:
2991: IF l_return_status = FND_API.G_RET_STS_ERROR OR
2992: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;

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

3005: -- Standard call to get message count and if count is 1, get message info
3006: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3007:
3008:
3009: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
3010: EXCEPTION
3011: WHEN FND_API.G_EXC_ERROR THEN
3012: ROLLBACK TO Create_Default_Contact_PVT;
3013: x_return_status := FND_API.G_RET_STS_ERROR;