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.OKL_AM_RECYCLE_TRMNT_PUB dependencies on OKL_DEBUG_PUB

Line 27: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

23: l_msg_data VARCHAR2(2000);
24: lp_recy_rec recy_rec_type;
25: lx_recy_rec recy_rec_type;
26: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
27: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
28: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
29: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
30:
31: BEGIN

Line 28: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

24: lp_recy_rec recy_rec_type;
25: lx_recy_rec recy_rec_type;
26: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
27: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
28: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
29: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
30:
31: BEGIN
32: SAVEPOINT trx_recycle_termination;

Line 29: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

25: lx_recy_rec recy_rec_type;
26: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
27: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
28: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
29: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
30:
31: BEGIN
32: SAVEPOINT trx_recycle_termination;
33: IF (is_debug_procedure_on) THEN

Line 34: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

30:
31: BEGIN
32: SAVEPOINT trx_recycle_termination;
33: IF (is_debug_procedure_on) THEN
34: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
35: END IF;
36: IF (is_debug_statement_on) THEN
37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);

Line 37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);

33: IF (is_debug_procedure_on) THEN
34: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
35: END IF;
36: IF (is_debug_statement_on) THEN
37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);

Line 38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);

34: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
35: END IF;
36: IF (is_debug_statement_on) THEN
37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);

Line 39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);

35: END IF;
36: IF (is_debug_statement_on) THEN
37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);
43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);

Line 40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);

36: IF (is_debug_statement_on) THEN
37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);
43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);
44: END IF;

Line 41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);

37: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_id: ' || p_recy_rec.p_contract_id);
38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);
43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);
44: END IF;
45:

Line 42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);

38: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_number: ' || p_recy_rec.p_contract_number);
39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);
43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);
44: END IF;
45:
46: l_api_version := p_api_version ;

Line 43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);

39: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_contract_status: ' || p_recy_rec.p_contract_status);
40: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_id: ' || p_recy_rec.p_transaction_id);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_status: ' || p_recy_rec.p_transaction_status);
42: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_tmt_recycle_yn: ' || p_recy_rec.p_tmt_recycle_yn);
43: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_rec.p_transaction_date: ' || p_recy_rec.p_transaction_date);
44: END IF;
45:
46: l_api_version := p_api_version ;
47: l_init_msg_list := p_init_msg_list ;

Line 60: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination');

56:
57: -- call the insert of pvt
58:
59: IF (is_debug_statement_on) THEN
60: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination');
61: END IF;
62: OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination( p_api_version => l_api_version
63: ,p_init_msg_list => l_init_msg_list
64: ,x_msg_data => l_msg_data

Line 70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);

66: ,x_return_status => l_return_status
67: ,p_recy_rec => lp_recy_rec
68: ,x_recy_rec => lx_recy_rec) ;
69: IF (is_debug_statement_on) THEN
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
71: END IF;
72:
73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
74: RAISE FND_API.G_EXC_ERROR;

Line 90: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

86: x_return_status := l_return_status ;
87: x_msg_count := l_msg_count ;
88: x_msg_data := l_msg_data ;
89: IF (is_debug_procedure_on) THEN
90: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
91: END IF;
92:
93: EXCEPTION
94:

Line 104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');

100: FND_MSG_PUB.count_and_get(
101: p_count => x_msg_count
102: ,p_data => x_msg_data);
103: IF (is_debug_exception_on) THEN
104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
105: END IF;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: ROLLBACK TO trx_recycle_termination;
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 115: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');

111: FND_MSG_PUB.count_and_get(
112: p_count => x_msg_count
113: ,p_data => x_msg_data);
114: IF (is_debug_exception_on) THEN
115: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
116: END IF;
117: WHEN OTHERS THEN
118: ROLLBACK TO trx_recycle_termination;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

123: FND_MSG_PUB.count_and_get(
124: p_count => x_msg_count
125: ,p_data => x_msg_data);
126: IF (is_debug_exception_on) THEN
127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
128: || sqlcode || ' , SQLERRM : ' || sqlerrm);
129: END IF;
130: END recycle_termination;
131:

Line 149: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

145: l_msg_data VARCHAR2(2000);
146: lp_recy_tbl recy_tbl_type;
147: lx_recy_tbl recy_tbl_type;
148: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
149: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
150: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
151: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
152:
153: BEGIN

Line 150: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

146: lp_recy_tbl recy_tbl_type;
147: lx_recy_tbl recy_tbl_type;
148: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
149: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
150: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
151: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
152:
153: BEGIN
154: SAVEPOINT trx_recycle_termination;

Line 151: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

147: lx_recy_tbl recy_tbl_type;
148: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'recycle_termination';
149: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
150: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
151: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
152:
153: BEGIN
154: SAVEPOINT trx_recycle_termination;
155: IF (is_debug_procedure_on) THEN

Line 156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');

152:
153: BEGIN
154: SAVEPOINT trx_recycle_termination;
155: IF (is_debug_procedure_on) THEN
156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
157: END IF;
158: IF (is_debug_statement_on) THEN
159: FOR i IN p_recy_tbl.FIRST..p_recy_tbl.LAST
160: LOOP

Line 162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);

158: IF (is_debug_statement_on) THEN
159: FOR i IN p_recy_tbl.FIRST..p_recy_tbl.LAST
160: LOOP
161: IF p_recy_tbl.EXISTS(i) THEN
162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);

Line 163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);

159: FOR i IN p_recy_tbl.FIRST..p_recy_tbl.LAST
160: LOOP
161: IF p_recy_tbl.EXISTS(i) THEN
162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);

Line 164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);

160: LOOP
161: IF p_recy_tbl.EXISTS(i) THEN
162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);
168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);

Line 165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);

161: IF p_recy_tbl.EXISTS(i) THEN
162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);
168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);
169: END IF;

Line 166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);

162: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_id: ' || p_recy_tbl(i).p_contract_id);
163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);
168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);
169: END IF;
170: END LOOP;

Line 167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);

163: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_number: ' || p_recy_tbl(i).p_contract_number);
164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);
168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);
169: END IF;
170: END LOOP;
171: END IF;

Line 168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);

164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_contract_status: ' || p_recy_tbl(i).p_contract_status);
165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_id: ' || p_recy_tbl(i).p_transaction_id);
166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_status: ' || p_recy_tbl(i).p_transaction_status);
167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_tmt_recycle_yn: ' || p_recy_tbl(i).p_tmt_recycle_yn);
168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_recy_tbl(' || i || ').p_transaction_date: ' || p_recy_tbl(i).p_transaction_date);
169: END IF;
170: END LOOP;
171: END IF;
172:

Line 187: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination');

183:
184: -- call the insert of pvt
185:
186: IF (is_debug_statement_on) THEN
187: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination');
188: END IF;
189: OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination( p_api_version => l_api_version
190: ,p_init_msg_list => l_init_msg_list
191: ,x_msg_data => l_msg_data

Line 197: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);

193: ,x_return_status => l_return_status
194: ,p_recy_tbl => lp_recy_tbl
195: ,x_recy_tbl => lx_recy_tbl) ;
196: IF (is_debug_statement_on) THEN
197: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
198: END IF;
199:
200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
201: RAISE FND_API.G_EXC_ERROR;

Line 217: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');

213: x_return_status := l_return_status ;
214: x_msg_count := l_msg_count ;
215: x_msg_data := l_msg_data ;
216: IF (is_debug_procedure_on) THEN
217: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
218: END IF;
219:
220: EXCEPTION
221:

Line 231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');

227: FND_MSG_PUB.count_and_get(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230: IF (is_debug_exception_on) THEN
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
232: END IF;
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ROLLBACK TO trx_recycle_termination;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');

238: FND_MSG_PUB.count_and_get(
239: p_count => x_msg_count
240: ,p_data => x_msg_data);
241: IF (is_debug_exception_on) THEN
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
243: END IF;
244: WHEN OTHERS THEN
245: ROLLBACK TO trx_recycle_termination;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 254: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

250: FND_MSG_PUB.count_and_get(
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: IF (is_debug_exception_on) THEN
254: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
255: || sqlcode || ' , SQLERRM : ' || sqlerrm);
256: END IF;
257:
258: END recycle_termination;