DBA Data[Home] [Help]

APPS.HZ_CREDIT_REQUEST_PVT dependencies on OE_DEBUG_PUB

Line 59: oe_debug_pub.add('In Release_Order_CC_Hold');

55: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type := OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
56:
57: BEGIN
58: IF G_debug_flag = 'Y' THEN
59: oe_debug_pub.add('In Release_Order_CC_Hold');
60: END IF;
61: l_return_status := FND_API.G_RET_STS_SUCCESS;
62: IF G_debug_flag = 'Y' THEN
63: oe_debug_pub.add('Check if Holds exist to release ');

Line 63: oe_debug_pub.add('Check if Holds exist to release ');

59: oe_debug_pub.add('In Release_Order_CC_Hold');
60: END IF;
61: l_return_status := FND_API.G_RET_STS_SUCCESS;
62: IF G_debug_flag = 'Y' THEN
63: oe_debug_pub.add('Check if Holds exist to release ');
64: END IF;
65:
66: -- check whether holds exists
67: oe_debug_pub.add('Calling OE_HOLDS_PUB.Check_Holds ');

Line 67: oe_debug_pub.add('Calling OE_HOLDS_PUB.Check_Holds ');

63: oe_debug_pub.add('Check if Holds exist to release ');
64: END IF;
65:
66: -- check whether holds exists
67: oe_debug_pub.add('Calling OE_HOLDS_PUB.Check_Holds ');
68: oe_debug_pub.add('p_wf_item :: '||OE_Credit_Engine_GRP.G_cc_hold_item_type);
69: oe_debug_pub.add('p_wf_activity :: '||OE_Credit_Engine_GRP.G_cc_hold_activity_name);
70:
71: OE_HOLDS_PUB.Check_Holds ( p_api_version => 1.0 ,

Line 68: oe_debug_pub.add('p_wf_item :: '||OE_Credit_Engine_GRP.G_cc_hold_item_type);

64: END IF;
65:
66: -- check whether holds exists
67: oe_debug_pub.add('Calling OE_HOLDS_PUB.Check_Holds ');
68: oe_debug_pub.add('p_wf_item :: '||OE_Credit_Engine_GRP.G_cc_hold_item_type);
69: oe_debug_pub.add('p_wf_activity :: '||OE_Credit_Engine_GRP.G_cc_hold_activity_name);
70:
71: OE_HOLDS_PUB.Check_Holds ( p_api_version => 1.0 ,
72: p_header_id => p_header_id ,

Line 69: oe_debug_pub.add('p_wf_activity :: '||OE_Credit_Engine_GRP.G_cc_hold_activity_name);

65:
66: -- check whether holds exists
67: oe_debug_pub.add('Calling OE_HOLDS_PUB.Check_Holds ');
68: oe_debug_pub.add('p_wf_item :: '||OE_Credit_Engine_GRP.G_cc_hold_item_type);
69: oe_debug_pub.add('p_wf_activity :: '||OE_Credit_Engine_GRP.G_cc_hold_activity_name);
70:
71: OE_HOLDS_PUB.Check_Holds ( p_api_version => 1.0 ,
72: p_header_id => p_header_id ,
73: p_hold_id => 1 ,

Line 84: oe_debug_pub.add('Out Check_Holds ');

80: x_msg_data => l_msg_data ,
81: x_return_status => l_return_status
82: );
83: IF G_debug_flag = 'Y' THEN
84: oe_debug_pub.add('Out Check_Holds ');
85: oe_debug_pub.add('l_return_status = '|| l_return_status );
86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 85: oe_debug_pub.add('l_return_status = '|| l_return_status );

81: x_return_status => l_return_status
82: );
83: IF G_debug_flag = 'Y' THEN
84: oe_debug_pub.add('Out Check_Holds ');
85: oe_debug_pub.add('l_return_status = '|| l_return_status );
86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;

Line 86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );

82: );
83: IF G_debug_flag = 'Y' THEN
84: oe_debug_pub.add('Out Check_Holds ');
85: oe_debug_pub.add('l_return_status = '|| l_return_status );
86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 103: oe_debug_pub.add('Attempt to Release hold on '|| p_header_id);

99: l_hold_release_rec.release_reason_code := 'OCM_AUTOMATIC'; --9865613
100: l_hold_release_rec.release_comment := 'Approved by Credit Manager' ;
101: l_hold_release_rec.created_by := p_user_id; -- Manually Released By Credit Manager
102: IF G_debug_flag = 'Y' THEN
103: oe_debug_pub.add('Attempt to Release hold on '|| p_header_id);
104: END IF;
105: IF NVL(p_calling_action, 'BOOKING') <> 'AUTO HOLD' THEN
106: OE_Holds_PUB.Release_Holds ( p_api_version => 1.0 ,
107: p_hold_source_rec => l_hold_source_rec ,

Line 119: oe_debug_pub.add('Released credit check hold on Header ID:'|| p_header_id);

115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
118: IF G_debug_flag = 'Y' THEN
119: oe_debug_pub.add('Released credit check hold on Header ID:'|| p_header_id);
120: END IF;
121: END IF;
122: l_cc_result_out := 'PASS_REL';
123: END IF; -- calling action check

Line 127: oe_debug_pub.add('Out Release_Order_CC_Hold');

123: END IF; -- calling action check
124: END IF; -- hold exist
125: x_cc_result_out := l_cc_result_out;
126: IF G_debug_flag = 'Y' THEN
127: oe_debug_pub.add('Out Release_Order_CC_Hold');
128: END IF;
129: EXCEPTION
130: WHEN OTHERS THEN
131: oe_debug_pub.add('EXCEPTION :: Release_Order_CC_Hold' );

Line 131: oe_debug_pub.add('EXCEPTION :: Release_Order_CC_Hold' );

127: oe_debug_pub.add('Out Release_Order_CC_Hold');
128: END IF;
129: EXCEPTION
130: WHEN OTHERS THEN
131: oe_debug_pub.add('EXCEPTION :: Release_Order_CC_Hold' );
132: RAISE;
133: END Release_Order_CC_Hold;
134:
135: --------------------------------------------------------------------------------------------

Line 173: oe_debug_pub.add(' In Release_Line_CC_Hold');

169: OE_HOLDS_PVT.G_MISS_Hold_Release_REC;
170: BEGIN
171: IF G_debug_flag = 'Y'
172: THEN
173: oe_debug_pub.add(' In Release_Line_CC_Hold');
174: oe_debug_pub.add('Processing line ID = '|| p_line_id );
175: END IF;
176:
177: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 174: oe_debug_pub.add('Processing line ID = '|| p_line_id );

170: BEGIN
171: IF G_debug_flag = 'Y'
172: THEN
173: oe_debug_pub.add(' In Release_Line_CC_Hold');
174: oe_debug_pub.add('Processing line ID = '|| p_line_id );
175: END IF;
176:
177: l_return_status := FND_API.G_RET_STS_SUCCESS;
178:

Line 183: OE_DEBUG_PUB.ADD('Check for holds for Header/Line ID : '|| p_header_id || '/' || p_line_id);

179:
180: --checking whether HOLD exists
181: IF G_debug_flag = 'Y'
182: THEN
183: OE_DEBUG_PUB.ADD('Check for holds for Header/Line ID : '|| p_header_id || '/' || p_line_id);
184: END IF;
185:
186: OE_HOLDS_PUB.Check_Holds
187: ( p_api_version => 1.0

Line 203: OE_DEBUG_PUB.ADD('Out Check_Holds');

199: );
200:
201: IF G_debug_flag = 'Y'
202: THEN
203: OE_DEBUG_PUB.ADD('Out Check_Holds');
204: OE_DEBUG_PUB.ADD('l_return_status :'||l_return_status);
205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);
206: END IF;
207:

Line 204: OE_DEBUG_PUB.ADD('l_return_status :'||l_return_status);

200:
201: IF G_debug_flag = 'Y'
202: THEN
203: OE_DEBUG_PUB.ADD('Out Check_Holds');
204: OE_DEBUG_PUB.ADD('l_return_status :'||l_return_status);
205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);
206: END IF;
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);

201: IF G_debug_flag = 'Y'
202: THEN
203: OE_DEBUG_PUB.ADD('Out Check_Holds');
204: OE_DEBUG_PUB.ADD('l_return_status :'||l_return_status);
205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);
206: END IF;
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;

Line 257: OE_DEBUG_PUB.ADD(' No Hold exist to be Released ');

253: END IF; -- check calling action
254: ELSE
255: IF G_debug_flag = 'Y'
256: THEN
257: OE_DEBUG_PUB.ADD(' No Hold exist to be Released ');
258: END IF;
259: END IF; -- Holds Exist IF
260:
261: x_cc_result_out := l_cc_result_out;

Line 265: OE_DEBUG_PUB.ADD('x_cc_result_out = '|| x_cc_result_out );

261: x_cc_result_out := l_cc_result_out;
262:
263: IF G_debug_flag = 'Y'
264: THEN
265: OE_DEBUG_PUB.ADD('x_cc_result_out = '|| x_cc_result_out );
266: OE_DEBUG_PUB.ADD('Out Release_Line_CC_Hold');
267: END IF;
268:
269: EXCEPTION

Line 266: OE_DEBUG_PUB.ADD('Out Release_Line_CC_Hold');

262:
263: IF G_debug_flag = 'Y'
264: THEN
265: OE_DEBUG_PUB.ADD('x_cc_result_out = '|| x_cc_result_out );
266: OE_DEBUG_PUB.ADD('Out Release_Line_CC_Hold');
267: END IF;
268:
269: EXCEPTION
270: WHEN OTHERS THEN

Line 271: OE_DEBUG_PUB.ADD('EXCEPTION :: Release_LINE_CC_Hold' );

267: END IF;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: OE_DEBUG_PUB.ADD('EXCEPTION :: Release_LINE_CC_Hold' );
272: RAISE;
273: RAISE;
274:
275: END Release_Line_CC_Hold;

Line 635: oe_debug_pub.add('OEXCRRQB Line Level, Party ID= '||l_party_id||' -Orig Chk Level- '||l_credit_check_rule_rec.credit_check_level_code);

631: END LOOP;
632: END IF;
633: --13987649 Start
634: ELSIF nvl(l_party_id,-99) > 0 THEN
635: oe_debug_pub.add('OEXCRRQB Line Level, Party ID= '||l_party_id||' -Orig Chk Level- '||l_credit_check_rule_rec.credit_check_level_code);
636: l_credit_check_rule_rec.credit_check_level_code := 'ORDER';
637: OE_CREDIT_CHECK_UTIL.GET_transaction_amount
638: ( p_header_id => l_source_column1
639: , p_transaction_curr_code => l_trx_currency