DBA Data[Home] [Help]

APPS.IBE_QUOTE_CHECKOUT_PVT dependencies on IBE_UTIL

Line 71: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

67:
68: BEGIN
69:
70:
71: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
72: IBE_UTIL.DEBUG('Inside Authorize_Credit_Card api');
73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');
74: END IF;
75:

Line 72: IBE_UTIL.DEBUG('Inside Authorize_Credit_Card api');

68: BEGIN
69:
70:
71: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
72: IBE_UTIL.DEBUG('Inside Authorize_Credit_Card api');
73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');
74: END IF;
75:
76: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');

69:
70:
71: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
72: IBE_UTIL.DEBUG('Inside Authorize_Credit_Card api');
73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');
74: END IF;
75:
76: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
77: IBE_UTIL.DEBUG('Authorize_Credit_Card:FND_MSG_PUB.initialized');

Line 76: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

72: IBE_UTIL.DEBUG('Inside Authorize_Credit_Card api');
73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');
74: END IF;
75:
76: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
77: IBE_UTIL.DEBUG('Authorize_Credit_Card:FND_MSG_PUB.initialized');
78: END IF;
79:
80: open c_get_trxn_extn_id(p_qte_Header_Id);

Line 77: IBE_UTIL.DEBUG('Authorize_Credit_Card:FND_MSG_PUB.initialized');

73: IBE_UTIL.DEBUG('PRAGMA AUTONOMOUS_TRANSACTION');
74: END IF;
75:
76: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
77: IBE_UTIL.DEBUG('Authorize_Credit_Card:FND_MSG_PUB.initialized');
78: END IF;
79:
80: open c_get_trxn_extn_id(p_qte_Header_Id);
81: fetch c_get_trxn_extn_id into l_trxn_extension_id;

Line 84: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

80: open c_get_trxn_extn_id(p_qte_Header_Id);
81: fetch c_get_trxn_extn_id into l_trxn_extension_id;
82: close c_get_trxn_extn_id;
83:
84: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
85: IBE_UTIL.DEBUG('Authorize_Credit_Card: After trxn query - l_trxn_extension_id' || l_trxn_extension_id);
86: END IF;
87:
88: open c_get_quote_details(p_qte_Header_Id);

Line 85: IBE_UTIL.DEBUG('Authorize_Credit_Card: After trxn query - l_trxn_extension_id' || l_trxn_extension_id);

81: fetch c_get_trxn_extn_id into l_trxn_extension_id;
82: close c_get_trxn_extn_id;
83:
84: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
85: IBE_UTIL.DEBUG('Authorize_Credit_Card: After trxn query - l_trxn_extension_id' || l_trxn_extension_id);
86: END IF;
87:
88: open c_get_quote_details(p_qte_Header_Id);
89: -- bug 16466998 fetch c_get_quote_details into l_auth_amount, l_trxn_currency_code, l_party_id, l_resource_id, l_quote_source_code;

Line 93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

89: -- bug 16466998 fetch c_get_quote_details into l_auth_amount, l_trxn_currency_code, l_party_id, l_resource_id, l_quote_source_code;
90: fetch c_get_quote_details into l_auth_amount, l_trxn_currency_code, l_party_id, l_resource_id, l_quote_source_code, l_cust_account_id;
91: close c_get_quote_details;
92:
93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);

Line 94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);

90: fetch c_get_quote_details into l_auth_amount, l_trxn_currency_code, l_party_id, l_resource_id, l_quote_source_code, l_cust_account_id;
91: close c_get_quote_details;
92:
93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);

Line 95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);

91: close c_get_quote_details;
92:
93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);

Line 96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);

92:
93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);
100: END IF;

Line 97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);

93: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);
100: END IF;
101:

Line 98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);

94: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_trxn_currency_code'|| l_trxn_currency_code);
95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);
100: END IF;
101:
102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null

Line 99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);

95: IBE_UTIL.DEBUG('Authorize_Credit_Card:Amount populated...'|| l_auth_amount);
96: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_party_id populated...'|| l_party_id);
97: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);
100: END IF;
101:
102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null
103: and l_quote_source_code = 'Order Capture Quotes') THEN

Line 104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

100: END IF;
101:
102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null
103: and l_quote_source_code = 'Order Capture Quotes') THEN
104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
105: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_resource_id not null and is Order Capture Quote. Get the org_id');
106: END IF;
107:
108: open c_get_org_id(l_party_id);

Line 105: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_resource_id not null and is Order Capture Quote. Get the org_id');

101:
102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null
103: and l_quote_source_code = 'Order Capture Quotes') THEN
104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
105: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_resource_id not null and is Order Capture Quote. Get the org_id');
106: END IF;
107:
108: open c_get_org_id(l_party_id);
109: fetch c_get_org_id into l_org_id;

Line 111: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

107:
108: open c_get_org_id(l_party_id);
109: fetch c_get_org_id into l_org_id;
110: if c_get_org_id%NOTFOUND THEN
111: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
112: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_org_id not found');
113: END IF;
114: else
115: l_party_id := l_org_id;

Line 112: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_org_id not found');

108: open c_get_org_id(l_party_id);
109: fetch c_get_org_id into l_org_id;
110: if c_get_org_id%NOTFOUND THEN
111: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
112: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_org_id not found');
113: END IF;
114: else
115: l_party_id := l_org_id;
116: end if;

Line 120: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

116: end if;
117: close c_get_org_id;
118:
119:
120: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
121: IBE_UTIL.DEBUG('Authorize_Credit_Card: After getting the org_id- party_id is '||l_party_id);
122: END IF;
123: END IF;
124:

Line 121: IBE_UTIL.DEBUG('Authorize_Credit_Card: After getting the org_id- party_id is '||l_party_id);

117: close c_get_org_id;
118:
119:
120: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
121: IBE_UTIL.DEBUG('Authorize_Credit_Card: After getting the org_id- party_id is '||l_party_id);
122: END IF;
123: END IF;
124:
125: l_payer.payment_function := 'CUSTOMER_PAYMENT';

Line 136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

132:
133: -- bug 16466998
134: l_payer.cust_account_id := l_cust_account_id;
135:
136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);

Line 137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);

133: -- bug 16466998
134: l_payer.cust_account_id := l_cust_account_id;
135:
136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);

Line 138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');

134: l_payer.cust_account_id := l_cust_account_id;
135:
136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);

Line 139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);

135:
136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);

Line 140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);

136: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);

Line 141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);

137: IBE_UTIL.DEBUG('Authorize_Credit_Card:Before call to create auth trxn_extension_id is: '||l_trxn_extension_id);
138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);

Line 142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);

138: IBE_UTIL.DEBUG('Authorize_Credit_Card:Payer context values ...');
139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);
146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');

Line 143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);

139: IBE_UTIL.DEBUG('Authorize_Credit_Card:payment function'||l_payment_function);
140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);
146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');
147: END IF;

Line 144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);

140: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_payer.party_id'||l_party_id);
141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);
146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');
147: END IF;
148:

Line 145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);

141: IBE_UTIL.DEBUG('Authorize_Credit_Card:amount is '||l_amount.value);
142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);
146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');
147: END IF;
148:
149:

Line 146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');

142: IBE_UTIL.DEBUG('Authorize_Credit_Card:currency is '||l_amount.currency_code);
143: IBE_UTIL.DEBUG('Authorize_Credit_Card:risk eval flag is '||l_auth_attribs.RiskEval_Enable_Flag);
144: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id is '||l_cust_account_id);
145: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_payer.cust_account_id is '||l_payer.cust_account_id);
146: IBE_UTIL.DEBUG('Authorize_Credit_Card:Calling IBY_Fndcpt_Trxn_Pub.Create_Authorization ');
147: END IF;
148:
149:
150: IBY_Fndcpt_Trxn_Pub.Create_Authorization

Line 165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

161: x_auth_result => l_auth_result,
162: x_response => l_response);
163:
164:
165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');
167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);
168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);

Line 166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');

162: x_response => l_response);
163:
164:
165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');
167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);
168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:

Line 167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);

163:
164:
165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');
167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);
168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:
171: if(l_response.result_code = 'IBY_0001' or l_response.result_code = 'COMMUNICATION_ERROR') then

Line 168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);

164:
165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');
167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);
168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:
171: if(l_response.result_code = 'IBY_0001' or l_response.result_code = 'COMMUNICATION_ERROR') then
172: IBE_UTIL.DEBUG('Authorize_Credit_Card: There was some communication error');

Line 169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);

165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
166: IBE_UTIL.DEBUG('Authorize_Credit_Card: After call to IBY_Fndcpt_Trxn_Pub.Create_Authorization');
167: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_return_status:'||l_return_status);
168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:
171: if(l_response.result_code = 'IBY_0001' or l_response.result_code = 'COMMUNICATION_ERROR') then
172: IBE_UTIL.DEBUG('Authorize_Credit_Card: There was some communication error');
173: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);

Line 172: IBE_UTIL.DEBUG('Authorize_Credit_Card: There was some communication error');

168: IBE_UTIL.DEBUG('Authorize_Credit_Card: CC l_response.result_code '||l_response.result_code);
169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:
171: if(l_response.result_code = 'IBY_0001' or l_response.result_code = 'COMMUNICATION_ERROR') then
172: IBE_UTIL.DEBUG('Authorize_Credit_Card: There was some communication error');
173: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
174: end if;
175: END IF;
176:

Line 173: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);

169: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
170:
171: if(l_response.result_code = 'IBY_0001' or l_response.result_code = 'COMMUNICATION_ERROR') then
172: IBE_UTIL.DEBUG('Authorize_Credit_Card: There was some communication error');
173: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
174: end if;
175: END IF;
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN

Line 179: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

175: END IF;
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN
178:
179: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
180: IBE_UTIL.DEBUG('Authorize_Credit_Card:Authorization successful....Commiting the data');
181: END IF;
182: COMMIT;
183:

Line 180: IBE_UTIL.DEBUG('Authorize_Credit_Card:Authorization successful....Commiting the data');

176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN
178:
179: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
180: IBE_UTIL.DEBUG('Authorize_Credit_Card:Authorization successful....Commiting the data');
181: END IF;
182: COMMIT;
183:
184: ELSE

Line 185: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

181: END IF;
182: COMMIT;
183:
184: ELSE
185: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
186: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');
187: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);
188: END IF;
189:

Line 186: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');

182: COMMIT;
183:
184: ELSE
185: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
186: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');
187: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);
188: END IF;
189:
190: x_return_status := FND_API.G_RET_STS_ERROR;

Line 187: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);

183:
184: ELSE
185: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
186: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');
187: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);
188: END IF;
189:
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:

Line 197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

193: FND_MESSAGE.CLEAR;
194:
195: IF l_response.result_code = 'IBY_0020' or l_response.result_code = 'PAYMENT_SYS_REJECT' THEN
196:
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_UTIL.DEBUG('Authorize_Credit_Card: Payment Decline - PAYMENT_SYS_REJECT ');
199: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_count '|| x_msg_count);
200: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data '|| x_msg_data);
201: END IF;

Line 198: IBE_UTIL.DEBUG('Authorize_Credit_Card: Payment Decline - PAYMENT_SYS_REJECT ');

194:
195: IF l_response.result_code = 'IBY_0020' or l_response.result_code = 'PAYMENT_SYS_REJECT' THEN
196:
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_UTIL.DEBUG('Authorize_Credit_Card: Payment Decline - PAYMENT_SYS_REJECT ');
199: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_count '|| x_msg_count);
200: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data '|| x_msg_data);
201: END IF;
202:

Line 199: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_count '|| x_msg_count);

195: IF l_response.result_code = 'IBY_0020' or l_response.result_code = 'PAYMENT_SYS_REJECT' THEN
196:
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_UTIL.DEBUG('Authorize_Credit_Card: Payment Decline - PAYMENT_SYS_REJECT ');
199: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_count '|| x_msg_count);
200: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data '|| x_msg_data);
201: END IF;
202:
203: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_CC_AUTH_DECLINE');

Line 200: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data '|| x_msg_data);

196:
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_UTIL.DEBUG('Authorize_Credit_Card: Payment Decline - PAYMENT_SYS_REJECT ');
199: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_count '|| x_msg_count);
200: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data '|| x_msg_data);
201: END IF;
202:
203: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_CC_AUTH_DECLINE');
204: FND_MSG_PUB.ADD;

Line 207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

203: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_CC_AUTH_DECLINE');
204: FND_MSG_PUB.ADD;
205:
206: ELSE
207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
208: IBE_UTIL.DEBUG('Authorize_Credit_Card:Had some problem while processing the CC Auth.Setting common error msg ');
209: END IF;
210:
211: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_CC_AUTH_PROCESSING');

Line 208: IBE_UTIL.DEBUG('Authorize_Credit_Card:Had some problem while processing the CC Auth.Setting common error msg ');

204: FND_MSG_PUB.ADD;
205:
206: ELSE
207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
208: IBE_UTIL.DEBUG('Authorize_Credit_Card:Had some problem while processing the CC Auth.Setting common error msg ');
209: END IF;
210:
211: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_CC_AUTH_PROCESSING');
212: FND_MSG_PUB.ADD;

Line 221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

217: END IF;
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count ,
228: p_data => x_msg_data);
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233:

Line 230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);

226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count ,
228: p_data => x_msg_data);
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

232: RAISE FND_API.G_EXC_ERROR;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

242: p_data => x_msg_data);
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244:
245: WHEN OTHERS THEN
246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
248: END IF;
249:
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 247: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244:
245: WHEN OTHERS THEN
246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
248: END IF;
249:
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

Line 279: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

275: END Boolean_To_GBoolean;
276:
277: BEGIN
278:
279: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
280: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Start');
281: END IF;
282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 280: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Start');

276:
277: BEGIN
278:
279: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
280: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Start');
281: END IF;
282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);

Line 283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

279: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
280: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Start');
281: END IF;
282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
287: END IF;

Line 284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);

280: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Start');
281: END IF;
282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
287: END IF;
288:

Line 285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');

281: END IF;
282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
287: END IF;
288:
289: IF px_submit_control_rec.book_flag = FND_API.G_MISS_CHAR --OR

Line 286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');

282:
283: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
284: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
287: END IF;
288:
289: IF px_submit_control_rec.book_flag = FND_API.G_MISS_CHAR --OR
290: -- px_submit_control_rec.book_flag = 'F'

Line 295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

291: -- shouldn't be defaulting if F is passed in
292: THEN
293: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_qte_header_id);
294:
295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
296: IBE_Util.Debug('qte_payment_tbl.COUNT=' || l_qte_payment_tbl.COUNT);
297: END IF;
298: IF l_qte_payment_tbl.COUNT = 1 THEN
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 296: IBE_Util.Debug('qte_payment_tbl.COUNT=' || l_qte_payment_tbl.COUNT);

292: THEN
293: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_qte_header_id);
294:
295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
296: IBE_Util.Debug('qte_payment_tbl.COUNT=' || l_qte_payment_tbl.COUNT);
297: END IF;
298: IF l_qte_payment_tbl.COUNT = 1 THEN
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
300: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);

Line 299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
296: IBE_Util.Debug('qte_payment_tbl.COUNT=' || l_qte_payment_tbl.COUNT);
297: END IF;
298: IF l_qte_payment_tbl.COUNT = 1 THEN
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
300: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
301: END IF;
302: IF l_qte_payment_tbl(1).payment_type_code IN ('CREDIT_CARD', 'PO') THEN
303: /*IF l_qte_payment_tbl(1).payment_ref_number IS NOT NULL THEN

Line 300: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);

296: IBE_Util.Debug('qte_payment_tbl.COUNT=' || l_qte_payment_tbl.COUNT);
297: END IF;
298: IF l_qte_payment_tbl.COUNT = 1 THEN
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
300: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
301: END IF;
302: IF l_qte_payment_tbl(1).payment_type_code IN ('CREDIT_CARD', 'PO') THEN
303: /*IF l_qte_payment_tbl(1).payment_ref_number IS NOT NULL THEN
304: px_submit_control_rec.book_flag :=

Line 336: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

332: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
333: END IF;
334: END IF;
335:
336: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
337: IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
338: END IF;
339:
340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 337: IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);

333: END IF;
334: END IF;
335:
336: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
337: IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
338: END IF;
339:
340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
341: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Finishes');

Line 340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

336: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
337: IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
338: END IF;
339:
340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
341: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Finishes');
342: END IF;
343:
344: END Default_Order_State;

Line 341: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Finishes');

337: IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);
338: END IF;
339:
340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
341: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Default_Order_State Finishes');
342: END IF;
343:
344: END Default_Order_State;
345:

Line 458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

454: -- Initialize API return status to success
455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456:
457: -- API body
458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');
460: END IF;
461: IBE_Quote_Misc_pvt.log_environment_info();
462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');

455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456:
457: -- API body
458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');
460: END IF;
461: IBE_Quote_Misc_pvt.log_environment_info();
462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');

Line 462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');
460: END IF;
461: IBE_Quote_Misc_pvt.log_environment_info();
462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');
464: END IF;
465: --ibe_util.enable_debug;
466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');

459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');
460: END IF;
461: IBE_Quote_Misc_pvt.log_environment_info();
462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');
464: END IF;
465: --ibe_util.enable_debug;
466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');

Line 465: --ibe_util.enable_debug;

461: IBE_Quote_Misc_pvt.log_environment_info();
462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');
464: END IF;
465: --ibe_util.enable_debug;
466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');
468: END IF;
469:

Line 466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');
464: END IF;
465: --ibe_util.enable_debug;
466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');
468: END IF;
469:
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');

463: IBE_UTIL.DEBUG('SUBMITQUOTE: After Calling log_environment_info');
464: END IF;
465: --ibe_util.enable_debug;
466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');
468: END IF;
469:
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);

Line 470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

466: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');
468: END IF;
469:
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
472: END IF;
473: if (fnd_api.to_boolean(p_validate_user)) then
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);

467: IBE_Util.Debug('Begin IBE_Quote_Checkout_Pvt.SubmitQuote()');
468: END IF;
469:
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
472: END IF;
473: if (fnd_api.to_boolean(p_validate_user)) then
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');

Line 474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
472: END IF;
473: if (fnd_api.to_boolean(p_validate_user)) then
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
476: END IF;
477: -- User Authentication
478: IBE_Quote_Misc_pvt.Validate_User_Update(

Line 475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');

471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
472: END IF;
473: if (fnd_api.to_boolean(p_validate_user)) then
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
476: END IF;
477: -- User Authentication
478: IBE_Quote_Misc_pvt.Validate_User_Update(
479: p_init_msg_list => FND_API.G_TRUE

Line 497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

493:
494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
498: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');
499: END IF;
500: end if;
501:

Line 498: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');

494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
498: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');
499: END IF;
500: end if;
501:
502: l_qte_header_rec.quote_header_id := p_quote_header_id;

Line 506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

502: l_qte_header_rec.quote_header_id := p_quote_header_id;
503: /*IF p_sharee_number IS NOT NULL
504: AND p_sharee_number <> FND_API.G_MISS_NUM THEN
505: -- save cart check permisson
506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
507: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() starts');
508: END IF;
509:
510: IBE_Quote_Save_pvt.Save(

Line 507: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() starts');

503: /*IF p_sharee_number IS NOT NULL
504: AND p_sharee_number <> FND_API.G_MISS_NUM THEN
505: -- save cart check permisson
506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
507: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() starts');
508: END IF;
509:
510: IBE_Quote_Save_pvt.Save(
511: p_api_version_number => p_api_version_number

Line 525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

521: ,x_return_status => x_return_status
522: ,x_msg_count => x_msg_count
523: ,x_msg_data => x_msg_data);
524:
525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
527: END IF;
528:
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 526: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');

522: ,x_msg_count => x_msg_count
523: ,x_msg_data => x_msg_data);
524:
525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
527: END IF;
528:
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: RAISE FND_API.G_EXC_ERROR;

Line 542: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

538: l_qte_header_rec.last_update_date := l_last_update_date_tmp;
539:
540: END IF;*/
541:
542: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
543: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State starts');
544: END IF;
545:
546: l_submit_control_rec := p_submit_control_rec;

Line 543: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State starts');

539:
540: END IF;*/
541:
542: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
543: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State starts');
544: END IF;
545:
546: l_submit_control_rec := p_submit_control_rec;
547: Default_Order_State(p_qte_header_id => l_qte_header_rec.quote_header_id,

Line 550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

546: l_submit_control_rec := p_submit_control_rec;
547: Default_Order_State(p_qte_header_id => l_qte_header_rec.quote_header_id,
548: px_submit_control_Rec => l_submit_control_rec);
549:
550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
551: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State finishes. Control_Rec.book_flag = ' ||
552: l_submit_control_rec.book_flag);
553: END IF;
554:

Line 551: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State finishes. Control_Rec.book_flag = ' ||

547: Default_Order_State(p_qte_header_id => l_qte_header_rec.quote_header_id,
548: px_submit_control_Rec => l_submit_control_rec);
549:
550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
551: IBE_Util.Debug('ASO_Quote_Pub.Default_Order_State finishes. Control_Rec.book_flag = ' ||
552: l_submit_control_rec.book_flag);
553: END IF;
554:
555: -- Added for Contracts Integration

Line 559: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

555: -- Added for Contracts Integration
556:
557: IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS') = 'Y' ) THEN
558: -- check if the contract is associated to the quote. If not then retrieve the template id and pass it in header rec.
559: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
560: IBE_Util.Debug('Contracts feature is turned ON, before calling Contract get_terms_template');
561: END IF;
562: l_check_terms := OKC_TERMS_UTIL_GRP.Get_Terms_Template( p_doc_type => 'QUOTE',
563: p_doc_id => l_qte_header_rec.quote_header_id);

Line 560: IBE_Util.Debug('Contracts feature is turned ON, before calling Contract get_terms_template');

556:
557: IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS') = 'Y' ) THEN
558: -- check if the contract is associated to the quote. If not then retrieve the template id and pass it in header rec.
559: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
560: IBE_Util.Debug('Contracts feature is turned ON, before calling Contract get_terms_template');
561: END IF;
562: l_check_terms := OKC_TERMS_UTIL_GRP.Get_Terms_Template( p_doc_type => 'QUOTE',
563: p_doc_id => l_qte_header_rec.quote_header_id);
564: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 564: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

560: IBE_Util.Debug('Contracts feature is turned ON, before calling Contract get_terms_template');
561: END IF;
562: l_check_terms := OKC_TERMS_UTIL_GRP.Get_Terms_Template( p_doc_type => 'QUOTE',
563: p_doc_id => l_qte_header_rec.quote_header_id);
564: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
565: IBE_Util.Debug('After get_terms_template api, l_check_terms='||l_check_terms);
566: END IF;
567:
568: IF (l_check_terms is null) THEN

Line 565: IBE_Util.Debug('After get_terms_template api, l_check_terms='||l_check_terms);

561: END IF;
562: l_check_terms := OKC_TERMS_UTIL_GRP.Get_Terms_Template( p_doc_type => 'QUOTE',
563: p_doc_id => l_qte_header_rec.quote_header_id);
564: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
565: IBE_Util.Debug('After get_terms_template api, l_check_terms='||l_check_terms);
566: END IF;
567:
568: IF (l_check_terms is null) THEN
569: /*mannamra: changes for MOAC*/

Line 582: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

578: l_sold_to_party_id,
579: l_last_updated_by;
580: close c_get_quote_details;
581:
582: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
583: IBE_Util.Debug('Quote Source Code = '||l_quote_source_code);
584: IBE_Util.Debug('Sold To Party Id = '||l_sold_to_party_id);
585: IBE_Util.Debug('last updated by = '||l_last_updated_by);
586: END IF;

Line 583: IBE_Util.Debug('Quote Source Code = '||l_quote_source_code);

579: l_last_updated_by;
580: close c_get_quote_details;
581:
582: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
583: IBE_Util.Debug('Quote Source Code = '||l_quote_source_code);
584: IBE_Util.Debug('Sold To Party Id = '||l_sold_to_party_id);
585: IBE_Util.Debug('last updated by = '||l_last_updated_by);
586: END IF;
587:

Line 584: IBE_Util.Debug('Sold To Party Id = '||l_sold_to_party_id);

580: close c_get_quote_details;
581:
582: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
583: IBE_Util.Debug('Quote Source Code = '||l_quote_source_code);
584: IBE_Util.Debug('Sold To Party Id = '||l_sold_to_party_id);
585: IBE_Util.Debug('last updated by = '||l_last_updated_by);
586: END IF;
587:
588: -- for Express Checkout carts, use the last_updated_by column to get the Party Id. If the party Id is null then

Line 585: IBE_Util.Debug('last updated by = '||l_last_updated_by);

581:
582: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
583: IBE_Util.Debug('Quote Source Code = '||l_quote_source_code);
584: IBE_Util.Debug('Sold To Party Id = '||l_sold_to_party_id);
585: IBE_Util.Debug('last updated by = '||l_last_updated_by);
586: END IF;
587:
588: -- for Express Checkout carts, use the last_updated_by column to get the Party Id. If the party Id is null then
589: -- use the Sold To Party Id.

Line 608: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

604: END IF;
605:
606: -- Get the First Name and Last Name for the derived party id.
607: -- Call ibe_workflow_pvt.get_name_details.
608: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
609: IBE_Util.Debug('Before calling get_name_details, partyId = '||l_party_id);
610: END IF;
611:
612: IF (l_party_id is not null) THEN

Line 609: IBE_Util.Debug('Before calling get_name_details, partyId = '||l_party_id);

605:
606: -- Get the First Name and Last Name for the derived party id.
607: -- Call ibe_workflow_pvt.get_name_details.
608: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
609: IBE_Util.Debug('Before calling get_name_details, partyId = '||l_party_id);
610: END IF;
611:
612: IF (l_party_id is not null) THEN
613: IBE_WORKFLOW_PVT.get_name_details(

Line 626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

622: l_qte_header_rec.Customer_Name_And_Title := l_person_first_name ||' '||l_person_last_name;
623: l_qte_header_rec.Customer_Signature_Date := sysdate;
624: l_qte_header_rec.Contract_Template_Id := l_contract_template_id;
625:
626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);
628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);
629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);
630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');

Line 627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);

623: l_qte_header_rec.Customer_Signature_Date := sysdate;
624: l_qte_header_rec.Contract_Template_Id := l_contract_template_id;
625:
626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);
628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);
629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);
630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');
631: END IF;

Line 628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);

624: l_qte_header_rec.Contract_Template_Id := l_contract_template_id;
625:
626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);
628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);
629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);
630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');
631: END IF;
632:

Line 629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);

625:
626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);
628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);
629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);
630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');
631: END IF;
632:
633: -- Added for CC Authorization

Line 630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');

626: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
627: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Name_And_Title);
628: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Customer_Signature_Date);
629: IBE_Util.Debug('Customer Name and Title ='||l_qte_header_rec.Contract_Template_Id);
630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');
631: END IF;
632:
633: -- Added for CC Authorization
634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

630: IBE_Util.Debug('Before calling new ASO Submit Quote api with Header Rec');
631: END IF;
632:
633: -- Added for CC Authorization
634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
635: IBE_UTIL.Debug('l_CC_Auth_Prof = ' || l_CC_Auth_Prof);
636: IBE_Util.Debug('Checking if Authorize_Credit_Card() need to be called');
637: END IF;
638:

Line 635: IBE_UTIL.Debug('l_CC_Auth_Prof = ' || l_CC_Auth_Prof);

631: END IF;
632:
633: -- Added for CC Authorization
634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
635: IBE_UTIL.Debug('l_CC_Auth_Prof = ' || l_CC_Auth_Prof);
636: IBE_Util.Debug('Checking if Authorize_Credit_Card() need to be called');
637: END IF;
638:
639: IF l_CC_Auth_Prof = 'Y' THEN

Line 636: IBE_Util.Debug('Checking if Authorize_Credit_Card() need to be called');

632:
633: -- Added for CC Authorization
634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
635: IBE_UTIL.Debug('l_CC_Auth_Prof = ' || l_CC_Auth_Prof);
636: IBE_Util.Debug('Checking if Authorize_Credit_Card() need to be called');
637: END IF;
638:
639: IF l_CC_Auth_Prof = 'Y' THEN
640:

Line 643: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

639: IF l_CC_Auth_Prof = 'Y' THEN
640:
641: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
642: IF l_qte_payment_tbl.COUNT = 1 THEN
643: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
644: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
645: END IF;
646: l_payment_type_code := l_qte_payment_tbl(1).payment_type_code;
647: END IF;

Line 644: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);

640:
641: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
642: IF l_qte_payment_tbl.COUNT = 1 THEN
643: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
644: IBE_UTIL.Debug('qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
645: END IF;
646: l_payment_type_code := l_qte_payment_tbl(1).payment_type_code;
647: END IF;
648:

Line 653: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

649: open c_get_trxn_extn_id(l_qte_header_rec.quote_header_id);
650: fetch c_get_trxn_extn_id into l_trxn_extension_id;
651: close c_get_trxn_extn_id;
652:
653: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
654: IBE_Util.Debug('l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);
655: END IF;
656:
657: open c_get_auth_details(l_trxn_extension_id);

Line 654: IBE_Util.Debug('l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);

650: fetch c_get_trxn_extn_id into l_trxn_extension_id;
651: close c_get_trxn_extn_id;
652:
653: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
654: IBE_Util.Debug('l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);
655: END IF;
656:
657: open c_get_auth_details(l_trxn_extension_id);
658: fetch c_get_auth_details into l_auth_flag;

Line 663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

659: close c_get_auth_details;
660:
661: END IF;
662:
663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
664: IBE_Util.Debug('l_trxn_extension_id Auth Flag = '||l_auth_flag);
665: END IF;
666:
667: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN

Line 664: IBE_Util.Debug('l_trxn_extension_id Auth Flag = '||l_auth_flag);

660:
661: END IF;
662:
663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
664: IBE_Util.Debug('l_trxn_extension_id Auth Flag = '||l_auth_flag);
665: END IF;
666:
667: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
668: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 668: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

664: IBE_Util.Debug('l_trxn_extension_id Auth Flag = '||l_auth_flag);
665: END IF;
666:
667: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
668: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
669: IBE_Util.Debug('Going to call Authorize_Credit_Card');
670: END IF;
671: Authorize_Credit_Card(p_qte_header_id => l_qte_header_rec.quote_header_id
672: ,x_return_status => x_return_status

Line 669: IBE_Util.Debug('Going to call Authorize_Credit_Card');

665: END IF;
666:
667: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
668: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
669: IBE_Util.Debug('Going to call Authorize_Credit_Card');
670: END IF;
671: Authorize_Credit_Card(p_qte_header_id => l_qte_header_rec.quote_header_id
672: ,x_return_status => x_return_status
673: ,x_msg_count => x_msg_count

Line 676: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

672: ,x_return_status => x_return_status
673: ,x_msg_count => x_msg_count
674: ,x_msg_data => x_msg_data);
675:
676: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
677: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');
678: END IF;
679:
680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 677: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');

673: ,x_msg_count => x_msg_count
674: ,x_msg_data => x_msg_data);
675:
676: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
677: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');
678: END IF;
679:
680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

677: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');
678: END IF;
679:
680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
683: END IF;
684:
685: RAISE FND_API.G_EXC_ERROR;

Line 682: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');

678: END IF;
679:
680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
683: END IF;
684:
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

Line 689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
690: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
691: END IF;
692:
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 690: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');

686: END IF;
687:
688: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
690: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
691: END IF;
692:
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;

Line 697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: END IF;
696:
697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
698: IBE_Util.Debug('After Authorize_Credit_Card');
699: END IF;
700:
701: ASO_Quote_Pub.Submit_quote(

Line 698: IBE_Util.Debug('After Authorize_Credit_Card');

694: END IF;
695: END IF;
696:
697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
698: IBE_Util.Debug('After Authorize_Credit_Card');
699: END IF;
700:
701: ASO_Quote_Pub.Submit_quote(
702: P_Api_Version_Number => p_api_version_number

Line 713: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

709: ,x_msg_count => x_msg_count
710: ,x_msg_data => x_msg_data);
711:
712:
713: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
714: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() New api with Header Rec finishes, x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
715: END IF;
716: ELSE
717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 714: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() New api with Header Rec finishes, x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);

710: ,x_msg_data => x_msg_data);
711:
712:
713: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
714: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() New api with Header Rec finishes, x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
715: END IF;
716: ELSE
717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
718: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() starts');

Line 717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

713: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
714: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() New api with Header Rec finishes, x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
715: END IF;
716: ELSE
717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
718: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() starts');
719: END IF;
720:
721:

Line 718: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() starts');

714: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() New api with Header Rec finishes, x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
715: END IF;
716: ELSE
717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
718: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() starts');
719: END IF;
720:
721:
722: --CC Authorization when OKC_ENABLE_SALES_CONTRACTS is no starts

Line 724: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

720:
721:
722: --CC Authorization when OKC_ENABLE_SALES_CONTRACTS is no starts
723: IF l_CC_Auth_Prof = 'Y' THEN
724: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
725: IBE_Util.Debug('Credit card authorization when OKC profile isset to no starts');
726: END IF;
727: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
728: IF l_qte_payment_tbl.COUNT = 1 THEN

Line 725: IBE_Util.Debug('Credit card authorization when OKC profile isset to no starts');

721:
722: --CC Authorization when OKC_ENABLE_SALES_CONTRACTS is no starts
723: IF l_CC_Auth_Prof = 'Y' THEN
724: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
725: IBE_Util.Debug('Credit card authorization when OKC profile isset to no starts');
726: END IF;
727: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
728: IF l_qte_payment_tbl.COUNT = 1 THEN
729: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 729: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

725: IBE_Util.Debug('Credit card authorization when OKC profile isset to no starts');
726: END IF;
727: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
728: IF l_qte_payment_tbl.COUNT = 1 THEN
729: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
730: IBE_UTIL.Debug('Else: qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
731: END IF;
732: l_payment_type_code := l_qte_payment_tbl(1).payment_type_code;
733: END IF;

Line 730: IBE_UTIL.Debug('Else: qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);

726: END IF;
727: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_quote_Header_Id);
728: IF l_qte_payment_tbl.COUNT = 1 THEN
729: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
730: IBE_UTIL.Debug('Else: qte_payment_tbl(1).payment_type_code = ' || l_qte_payment_tbl(1).payment_type_code);
731: END IF;
732: l_payment_type_code := l_qte_payment_tbl(1).payment_type_code;
733: END IF;
734:

Line 739: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

735: open c_get_trxn_extn_id(l_qte_header_rec.quote_header_id);
736: fetch c_get_trxn_extn_id into l_trxn_extension_id;
737: close c_get_trxn_extn_id;
738:
739: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
740: IBE_Util.Debug('Else:l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);
741: END IF;
742:
743: open c_get_auth_details(l_trxn_extension_id);

Line 740: IBE_Util.Debug('Else:l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);

736: fetch c_get_trxn_extn_id into l_trxn_extension_id;
737: close c_get_trxn_extn_id;
738:
739: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
740: IBE_Util.Debug('Else:l_trxn_extension_id from aso_payments = '||l_trxn_extension_id);
741: END IF;
742:
743: open c_get_auth_details(l_trxn_extension_id);
744: fetch c_get_auth_details into l_auth_flag;

Line 749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

745: close c_get_auth_details;
746:
747: END IF;
748:
749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
750: IBE_Util.Debug('Else : l_trxn_extension_id Auth Flag = '||l_auth_flag);
751: END IF;
752:
753: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN

Line 750: IBE_Util.Debug('Else : l_trxn_extension_id Auth Flag = '||l_auth_flag);

746:
747: END IF;
748:
749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
750: IBE_Util.Debug('Else : l_trxn_extension_id Auth Flag = '||l_auth_flag);
751: END IF;
752:
753: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
754:

Line 755: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

751: END IF;
752:
753: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
754:
755: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
756: IBE_Util.Debug('Going to call Authorize_Credit_Card');
757: END IF;
758: Authorize_Credit_Card(p_qte_header_id => l_qte_header_rec.quote_header_id
759: ,x_return_status => x_return_status

Line 756: IBE_Util.Debug('Going to call Authorize_Credit_Card');

752:
753: IF l_CC_Auth_Prof = 'Y' and l_auth_flag = 'N' and l_payment_type_code='CREDIT_CARD' THEN
754:
755: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
756: IBE_Util.Debug('Going to call Authorize_Credit_Card');
757: END IF;
758: Authorize_Credit_Card(p_qte_header_id => l_qte_header_rec.quote_header_id
759: ,x_return_status => x_return_status
760: ,x_msg_count => x_msg_count

Line 763: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

759: ,x_return_status => x_return_status
760: ,x_msg_count => x_msg_count
761: ,x_msg_data => x_msg_data);
762:
763: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
764: IBE_Util.Debug('Else:After Authorize_Credit_Card checking the returned status');
765: END IF;
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 764: IBE_Util.Debug('Else:After Authorize_Credit_Card checking the returned status');

760: ,x_msg_count => x_msg_count
761: ,x_msg_data => x_msg_data);
762:
763: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
764: IBE_Util.Debug('Else:After Authorize_Credit_Card checking the returned status');
765: END IF;
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

764: IBE_Util.Debug('Else:After Authorize_Credit_Card checking the returned status');
765: END IF;
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
769: IBE_Util.Debug('Else:IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
770: END IF;
771:
772: RAISE FND_API.G_EXC_ERROR;

Line 769: IBE_Util.Debug('Else:IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');

765: END IF;
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
769: IBE_Util.Debug('Else:IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
770: END IF;
771:
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;

Line 776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
777: IBE_Util.Debug('Else:ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
778: END IF;
779:
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 777: IBE_Util.Debug('Else:ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');

773: END IF;
774:
775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
777: IBE_Util.Debug('Else:ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
778: END IF;
779:
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;

Line 784: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782: END IF;
783:
784: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
785: IBE_Util.Debug('Else:After Authorize_Credit_Card');
786: END IF;
787:
788: --CC Authorization when OKC_ENABLE_SALES_CONTRACTS is no ends

Line 785: IBE_Util.Debug('Else:After Authorize_Credit_Card');

781: END IF;
782: END IF;
783:
784: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
785: IBE_Util.Debug('Else:After Authorize_Credit_Card');
786: END IF;
787:
788: --CC Authorization when OKC_ENABLE_SALES_CONTRACTS is no ends
789:

Line 802: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

798: ,x_return_status => x_return_status
799: ,x_msg_count => x_msg_count
800: ,x_msg_data => x_msg_data);
801:
802: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
803: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
804: END IF;
805: END IF;
806: l_msg_data := x_msg_data;

Line 803: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);

799: ,x_msg_count => x_msg_count
800: ,x_msg_data => x_msg_data);
801:
802: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
803: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
804: END IF;
805: END IF;
806: l_msg_data := x_msg_data;
807: l_msg_count := x_msg_count;

Line 811: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

807: l_msg_count := x_msg_count;
808: l_return_status := x_return_status;
809:
810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
811: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
812: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
813: END IF;
814:
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 812: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');

808: l_return_status := x_return_status;
809:
810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
811: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
812: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
813: END IF;
814:
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;

Line 825: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

821: THEN
822: -- l_submit_control_rec := p_submit_control_rec;
823: l_submit_control_rec.book_flag := fnd_api.g_false;
824:
825: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
826: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure starts');
827: END IF;
828:
829: ASO_Quote_Pub.Submit_Quote(

Line 826: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure starts');

822: -- l_submit_control_rec := p_submit_control_rec;
823: l_submit_control_rec.book_flag := fnd_api.g_false;
824:
825: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
826: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure starts');
827: END IF;
828:
829: ASO_Quote_Pub.Submit_Quote(
830: p_api_version_number => p_api_version_number

Line 839: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

835: ,x_return_status => x_return_status
836: ,x_msg_count => x_msg_count
837: ,x_msg_data => x_msg_data);
838:
839: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
840: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
841: END IF;
842:
843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara

Line 840: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);

836: ,x_msg_count => x_msg_count
837: ,x_msg_data => x_msg_data);
838:
839: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
840: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
841: END IF;
842:
843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara
844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

840: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
841: END IF;
842:
843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara
844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
845: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;

Line 845: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');

841: END IF;
842:
843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara
844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
845: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;

Line 852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850:
851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
853: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
854: END IF;
855:
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 853: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');

849: END IF;
850:
851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
853: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
854: END IF;
855:
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;

Line 860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: ELSE
859:
860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
861: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;

Line 861: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');

857: END IF;
858: ELSE
859:
860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
861: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865: END IF;

Line 868: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

864: END IF;
865: END IF;
866:
867: -------------------------------------------------------------------------------------
868: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
869: IBE_Util.Debug('submitQuote: Calling oe_holds_pub.check_holds with header id '||x_Order_Header_Rec.ORDER_HEADER_ID);
870: END IF;
871:
872: oe_holds_pub.check_holds(p_api_version => 1

Line 869: IBE_Util.Debug('submitQuote: Calling oe_holds_pub.check_holds with header id '||x_Order_Header_Rec.ORDER_HEADER_ID);

865: END IF;
866:
867: -------------------------------------------------------------------------------------
868: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
869: IBE_Util.Debug('submitQuote: Calling oe_holds_pub.check_holds with header id '||x_Order_Header_Rec.ORDER_HEADER_ID);
870: END IF;
871:
872: oe_holds_pub.check_holds(p_api_version => 1
873: ,p_header_id => x_Order_Header_Rec.ORDER_HEADER_ID

Line 880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

876: ,x_msg_count => x_msg_count
877: ,x_msg_data => x_msg_data);
878:
879: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
881: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
882: END IF;
883:
884: RAISE FND_API.G_EXC_ERROR;

Line 881: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);

877: ,x_msg_data => x_msg_data);
878:
879: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
881: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
882: END IF;
883:
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;

Line 888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
889: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
890: END IF;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;

Line 889: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);

885: END IF;
886:
887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
889: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
890: END IF;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:

Line 921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

917:
918:
919: IF p_reason_code <> FND_API.G_MISS_CHAR
920: AND p_reason_code IS NOT NULL THEN
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
923: END IF;
924:
925: IBE_Workflow_Pvt.NotifyForSalesAssistance(

Line 922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');

918:
919: IF p_reason_code <> FND_API.G_MISS_CHAR
920: AND p_reason_code IS NOT NULL THEN
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
923: END IF;
924:
925: IBE_Workflow_Pvt.NotifyForSalesAssistance(
926: p_api_version => p_api_version_number

Line 936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

932: ,x_return_status => x_return_status
933: ,x_msg_count => x_msg_count
934: ,x_msg_data => x_msg_data);
935:
936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
938: END IF;
939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;

Line 937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');

933: ,x_msg_count => x_msg_count
934: ,x_msg_data => x_msg_data);
935:
936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
938: END IF;
939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;

Line 950: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

946: ELSE
947:
948: /*This part is to bock notifications for application in maintenance mode(High Availability)*/
949: /*If the state of application is among 2,3,4,5 then notifications are disabled*/
950: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
951: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state begins');
952: END IF;
953:
954: JTF_HA_STATE_PKG.Get_Current_state(x_current_state => l_current_state,

Line 951: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state begins');

947:
948: /*This part is to bock notifications for application in maintenance mode(High Availability)*/
949: /*If the state of application is among 2,3,4,5 then notifications are disabled*/
950: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
951: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state begins');
952: END IF;
953:
954: JTF_HA_STATE_PKG.Get_Current_state(x_current_state => l_current_state,
955: x_return_status => x_return_status);

Line 957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

953:
954: JTF_HA_STATE_PKG.Get_Current_state(x_current_state => l_current_state,
955: x_return_status => x_return_status);
956:
957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
958: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
959: END IF;
960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;

Line 958: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');

954: JTF_HA_STATE_PKG.Get_Current_state(x_current_state => l_current_state,
955: x_return_status => x_return_status);
956:
957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
958: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
959: END IF;
960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;

Line 969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;
967: IF(l_current_state NOT IN (2,3,4,5)) THEN
968:
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
971: END IF;
972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN

Line 970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');

966: END IF;
967: IF(l_current_state NOT IN (2,3,4,5)) THEN
968:
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
971: END IF;
972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
974: IBE_Workflow_Pvt.NotifyOrderStatus(

Line 1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1013: END IF;
1014:
1015:
1016: END IF;--for l_current_state(HA)
1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
1019: END IF;
1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;

Line 1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');

1014:
1015:
1016: END IF;--for l_current_state(HA)
1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
1019: END IF;
1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;

Line 1039: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1035: -- Standard call to get message count and IF count is 1, get message info.
1036: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count ,
1038: p_data => x_msg_data);
1039: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');
1041: END IF;
1042: --ibe_util.disable_debug;
1043: EXCEPTION

Line 1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');

1036: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count ,
1038: p_data => x_msg_data);
1039: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');
1041: END IF;
1042: --ibe_util.disable_debug;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN

Line 1042: --ibe_util.disable_debug;

1038: p_data => x_msg_data);
1039: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');
1041: END IF;
1042: --ibe_util.disable_debug;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');

Line 1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1041: END IF;
1042: --ibe_util.disable_debug;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1047: END IF;
1048: ROLLBACK TO SUBMITQUOTE_PVT;
1049: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');

1042: --ibe_util.disable_debug;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1047: END IF;
1048: ROLLBACK TO SUBMITQUOTE_PVT;
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1050: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count ,
1052: p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1056: END IF;
1057:
1058: ROLLBACK TO SUBMITQUOTE_PVT;

Line 1055: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');

1051: p_count => x_msg_count ,
1052: p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1056: END IF;
1057:
1058: ROLLBACK TO SUBMITQUOTE_PVT;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1064: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

1060: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1061: p_count => x_msg_count ,
1062: p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1065: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1066: END IF;
1067:
1068: ROLLBACK TO SUBMITQUOTE_PVT;

Line 1065: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.SubmitQuote');

1061: p_count => x_msg_count ,
1062: p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1065: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1066: END IF;
1067:
1068: ROLLBACK TO SUBMITQUOTE_PVT;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;