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_COLL_IND_PUB dependencies on IEX_COLL_IND_PUB

Line 1: PACKAGE BODY IEX_COLL_IND_PUB AS

1: PACKAGE BODY IEX_COLL_IND_PUB AS
2: /* $Header: iexpmtib.pls 120.1 2010/12/24 09:27:43 snuthala noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_COLL_IND_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpmtib.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_COLL_IND_PUB';

1: PACKAGE BODY IEX_COLL_IND_PUB AS
2: /* $Header: iexpmtib.pls 120.1 2010/12/24 09:27:43 snuthala noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_COLL_IND_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpmtib.pls';
6: G_APPL_ID NUMBER;
7: G_LOGIN_ID NUMBER;
8: G_PROGRAM_ID NUMBER;

Line 38: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_currency_code = ' ||g_base_currency_code);

34: mo_global.set_policy_context('S',p_org_id);
35:
36: GET_COMMON(p_org_id);
37:
38: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_currency_code = ' ||g_base_currency_code);
39: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_precision = ' ||g_base_precision);
40: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);
42:

Line 39: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_precision = ' ||g_base_precision);

35:
36: GET_COMMON(p_org_id);
37:
38: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_currency_code = ' ||g_base_currency_code);
39: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_precision = ' ||g_base_precision);
40: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);
42:
43: IF p_party_id IS NOT NULL THEN

Line 40: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_min_acc_unit = ' ||g_base_min_acc_unit);

36: GET_COMMON(p_org_id);
37:
38: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_currency_code = ' ||g_base_currency_code);
39: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_precision = ' ||g_base_precision);
40: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);
42:
43: IF p_party_id IS NOT NULL THEN
44: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL,

Line 41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);

37:
38: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_currency_code = ' ||g_base_currency_code);
39: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_precision = ' ||g_base_precision);
40: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
41: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_true_dso - p_org_id = ' ||p_org_id);
42:
43: IF p_party_id IS NOT NULL THEN
44: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL,
45: gl_currency_api.convert_amount_sql(prof_amt.currency_code,g_base_currency_code,

Line 90: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_credit_limit - Exception = ' ||SQLERRM);

86: RETURN l_char_val;
87:
88: EXCEPTION
89: when others then
90: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_credit_limit - Exception = ' ||SQLERRM);
91: RETURN(0);
92:
93: END GET_CREDIT_LIMIT;
94:

Line 187: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_wtd_days_terms - Exception = ' ||SQLERRM);

183: RETURN l_char_val;
184:
185: EXCEPTION
186: when others then
187: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_wtd_days_terms - Exception = ' ||SQLERRM);
188: RETURN(TO_CHAR(0));
189: END GET_WTD_DAYS_TERMS;
190:
191: FUNCTION GET_WTD_DAYS_LATE(p_party_id IN NUMBER,

Line 284: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_wtd_days_late - Exception = ' ||SQLERRM);

280: RETURN l_char_val;
281:
282: EXCEPTION
283: when others then
284: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_wtd_days_late - Exception = ' ||SQLERRM);
285: RETURN(TO_CHAR(0));
286: END GET_WTD_DAYS_LATE;
287:
288: FUNCTION GET_TRUE_DSO(p_party_id IN NUMBER,

Line 440: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_currency_code = ' ||g_base_currency_code);

436: where
437: gll.ledger_id = sp.set_of_books_id
438: and gll.currency_code = c.currency_code;
439:
440: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_currency_code = ' ||g_base_currency_code);
441: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_precision = ' ||g_base_precision);
442: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
443:
444:

Line 441: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_precision = ' ||g_base_precision);

437: gll.ledger_id = sp.set_of_books_id
438: and gll.currency_code = c.currency_code;
439:
440: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_currency_code = ' ||g_base_currency_code);
441: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_precision = ' ||g_base_precision);
442: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
443:
444:
445: exception

Line 442: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_min_acc_unit = ' ||g_base_min_acc_unit);

438: and gll.currency_code = c.currency_code;
439:
440: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_currency_code = ' ||g_base_currency_code);
441: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_precision = ' ||g_base_precision);
442: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.get_common - g_base_min_acc_unit = ' ||g_base_min_acc_unit);
443:
444:
445: exception
446: when others then

Line 447: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.main selection - Exception = ' ||SQLERRM);

443:
444:
445: exception
446: when others then
447: iex_debug_pub.logmessage (' IEX_COLL_IND_PUB.main selection - Exception = ' ||SQLERRM);
448: null;
449:
450: end GET_COMMON;
451:

Line 463: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES Start ');

459: l_char_val VARCHAR2(1000);
460:
461: BEGIN
462:
463: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES Start ');
464: mo_global.set_policy_context('S',p_org_id);
465:
466: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: Calling GET_COMMON with org_id: ' || p_org_id);
467: GET_COMMON(p_org_id);

Line 466: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: Calling GET_COMMON with org_id: ' || p_org_id);

462:
463: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES Start ');
464: mo_global.set_policy_context('S',p_org_id);
465:
466: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: Calling GET_COMMON with org_id: ' || p_org_id);
467: GET_COMMON(p_org_id);
468: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: After Calling GET_COMMON');
469:
470: l_sales := COMP_TOT_REC(TRUNC(add_months(sysdate, -12)), TRUNC(sysdate),

Line 468: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: After Calling GET_COMMON');

464: mo_global.set_policy_context('S',p_org_id);
465:
466: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: Calling GET_COMMON with org_id: ' || p_org_id);
467: GET_COMMON(p_org_id);
468: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: After Calling GET_COMMON');
469:
470: l_sales := COMP_TOT_REC(TRUNC(add_months(sysdate, -12)), TRUNC(sysdate),
471: p_party_id, p_cust_account_id, p_customer_site_use_id);
472:

Line 473: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_sales: ' || l_sales);

469:
470: l_sales := COMP_TOT_REC(TRUNC(add_months(sysdate, -12)), TRUNC(sysdate),
471: p_party_id, p_cust_account_id, p_customer_site_use_id);
472:
473: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_sales: ' || l_sales);
474: l_num_val := NVL(l_sales, 0);
475: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_base_currency_code, 50)));
476: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_char_val: ' || l_char_val);
477: RETURN l_char_val;

Line 476: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_char_val: ' || l_char_val);

472:
473: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_sales: ' || l_sales);
474: l_num_val := NVL(l_sales, 0);
475: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_base_currency_code, 50)));
476: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_char_val: ' || l_char_val);
477: RETURN l_char_val;
478: exception
479: when others then
480: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES - Exception = ' ||SQLERRM);

Line 480: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES - Exception = ' ||SQLERRM);

476: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES: l_char_val: ' || l_char_val);
477: RETURN l_char_val;
478: exception
479: when others then
480: iex_debug_pub.logmessage ('IEX_COLL_IND_PUB.GET_SALES - Exception = ' ||SQLERRM);
481: null;
482: END GET_SALES;
483: --End for bug 10091833 gnramasa 22nd Sep 10
484:

Line 485: END IEX_COLL_IND_PUB;

481: null;
482: END GET_SALES;
483: --End for bug 10091833 gnramasa 22nd Sep 10
484:
485: END IEX_COLL_IND_PUB;