DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on INV_LOG_UTIL

Line 14: inv_log_util.trace('tdatechk ' || nvl(G_ORG_ID, -1) || ' ' || nvl(G_TRANSACTION_DATE, trunc(sysdate)), 'tdatechk', 9);

10: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11: v_scheduled_close_date DATE;
12: begin
13: if( l_debug = 1 ) then
14: inv_log_util.trace('tdatechk ' || nvl(G_ORG_ID, -1) || ' ' || nvl(G_TRANSACTION_DATE, trunc(sysdate)), 'tdatechk', 9);
15: inv_log_util.trace('org_id = ' || org_id || ' transaction_date = ' || transaction_date, 'tdatechk', 9);
16: end if;
17: if( nvl(G_ORG_ID, -1) <> org_id OR nvl(G_TRANSACTION_DATE, trunc(sysdate)) <> trunc(nvl(transaction_date, sysdate)) OR G_PERIOD_STATUS <> 1) THEN
18: if( l_debug = 1 ) then

Line 15: inv_log_util.trace('org_id = ' || org_id || ' transaction_date = ' || transaction_date, 'tdatechk', 9);

11: v_scheduled_close_date DATE;
12: begin
13: if( l_debug = 1 ) then
14: inv_log_util.trace('tdatechk ' || nvl(G_ORG_ID, -1) || ' ' || nvl(G_TRANSACTION_DATE, trunc(sysdate)), 'tdatechk', 9);
15: inv_log_util.trace('org_id = ' || org_id || ' transaction_date = ' || transaction_date, 'tdatechk', 9);
16: end if;
17: if( nvl(G_ORG_ID, -1) <> org_id OR nvl(G_TRANSACTION_DATE, trunc(sysdate)) <> trunc(nvl(transaction_date, sysdate)) OR G_PERIOD_STATUS <> 1) THEN
18: if( l_debug = 1 ) then
19: inv_log_util.trace('will query database', 'tdatechk', 9);

Line 19: inv_log_util.trace('will query database', 'tdatechk', 9);

15: inv_log_util.trace('org_id = ' || org_id || ' transaction_date = ' || transaction_date, 'tdatechk', 9);
16: end if;
17: if( nvl(G_ORG_ID, -1) <> org_id OR nvl(G_TRANSACTION_DATE, trunc(sysdate)) <> trunc(nvl(transaction_date, sysdate)) OR G_PERIOD_STATUS <> 1) THEN
18: if( l_debug = 1 ) then
19: inv_log_util.trace('will query database', 'tdatechk', 9);
20: end if;
21: begin
22: period_id := 0;
23:

Line 54: inv_log_util.trace('get the value from global package var ' || g_transaction_period_id, 'tdatechk', 9);

50: G_PERIOD_STATUS := 0;
51: end;
52: else
53: if( l_debug = 1 ) then
54: inv_log_util.trace('get the value from global package var ' || g_transaction_period_id, 'tdatechk', 9);
55: end if;
56: v_transaction_period_id := G_TRANSACTION_PERIOD_ID;
57: period_id := G_TRANSACTION_PERIOD_ID;
58: end if;

Line 66: inv_log_util.trace('open_past_period is true', 'tdatechk', 9);

62:
63: begin
64: if (open_past_period) then
65: if( l_debug = 1 ) then
66: inv_log_util.trace('open_past_period is true', 'tdatechk', 9);
67: inv_log_util.trace('G_CURRENT_DATE is ' || trunc(nvl(G_CURRENT_DATE, sysdate)), 'tdatechk', 9);
68: end if;
69:
70: -- Bug 4737520 base bugfix 4721230 should still query the current_period_id, if cached g_current_period_id is null

Line 67: inv_log_util.trace('G_CURRENT_DATE is ' || trunc(nvl(G_CURRENT_DATE, sysdate)), 'tdatechk', 9);

63: begin
64: if (open_past_period) then
65: if( l_debug = 1 ) then
66: inv_log_util.trace('open_past_period is true', 'tdatechk', 9);
67: inv_log_util.trace('G_CURRENT_DATE is ' || trunc(nvl(G_CURRENT_DATE, sysdate)), 'tdatechk', 9);
68: end if;
69:
70: -- Bug 4737520 base bugfix 4721230 should still query the current_period_id, if cached g_current_period_id is null
71:

Line 74: inv_log_util.trace('going to query db', 'tdatechk', 9);

70: -- Bug 4737520 base bugfix 4721230 should still query the current_period_id, if cached g_current_period_id is null
71:
72: if( nvl(G_ORG_ID, -1) <> org_id OR trunc(nvl(G_CURRENT_DATE, sysdate)) <> trunc(sysdate) OR G_CURRENT_PERIOD_ID is NULL ) THEN
73: if l_debug = 1 then
74: inv_log_util.trace('going to query db', 'tdatechk', 9);
75: end if;
76: G_CURRENT_DATE := trunc(sysdate);
77:
78: SELECT ACCT_PERIOD_ID

Line 93: inv_log_util.trace('getting from cache ' || g_current_period_id, 'tdatechk', 9);

89: open_past_period := FALSE;
90: end if;
91: else
92: if l_debug = 1 then
93: inv_log_util.trace('getting from cache ' || g_current_period_id, 'tdatechk', 9);
94: end if;
95: if v_transaction_period_id <> G_CURRENT_PERIOD_ID THEN
96: open_past_period := FALSE;
97: end if;