eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CHG_ORDER_PVT dependencies on OE_DEBUG_PUB

Line 26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

22: , p_itemkey in VARCHAR2
23: )
24: IS
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27: --
28: BEGIN
29: IF l_debug_level > 0 THEN
30: oe_debug_pub.add( 'BEFORE START_CHANGEORDER FLOW' ) ;

Line 30: oe_debug_pub.add( 'BEFORE START_CHANGEORDER FLOW' ) ;

26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27: --
28: BEGIN
29: IF l_debug_level > 0 THEN
30: oe_debug_pub.add( 'BEFORE START_CHANGEORDER FLOW' ) ;
31: oe_debug_pub.add( 'ITEM TYPE IS :'|| P_ITEMTYPE ) ;
32: oe_debug_pub.add( 'ITEM KEY IS :' || P_ITEMKEY ) ;
33: END IF;
34:

Line 31: oe_debug_pub.add( 'ITEM TYPE IS :'|| P_ITEMTYPE ) ;

27: --
28: BEGIN
29: IF l_debug_level > 0 THEN
30: oe_debug_pub.add( 'BEFORE START_CHANGEORDER FLOW' ) ;
31: oe_debug_pub.add( 'ITEM TYPE IS :'|| P_ITEMTYPE ) ;
32: oe_debug_pub.add( 'ITEM KEY IS :' || P_ITEMKEY ) ;
33: END IF;
34:
35: WF_ENGINE.StartProcess(p_itemtype, p_itemkey);

Line 32: oe_debug_pub.add( 'ITEM KEY IS :' || P_ITEMKEY ) ;

28: BEGIN
29: IF l_debug_level > 0 THEN
30: oe_debug_pub.add( 'BEFORE START_CHANGEORDER FLOW' ) ;
31: oe_debug_pub.add( 'ITEM TYPE IS :'|| P_ITEMTYPE ) ;
32: oe_debug_pub.add( 'ITEM KEY IS :' || P_ITEMKEY ) ;
33: END IF;
34:
35: WF_ENGINE.StartProcess(p_itemtype, p_itemkey);
36: IF l_debug_level > 0 THEN

Line 37: oe_debug_pub.add( 'AFTER START_CHANGEORDER FLOW' ) ;

33: END IF;
34:
35: WF_ENGINE.StartProcess(p_itemtype, p_itemkey);
36: IF l_debug_level > 0 THEN
37: oe_debug_pub.add( 'AFTER START_CHANGEORDER FLOW' ) ;
38: END IF;
39: EXCEPTION
40: WHEN OTHERS THEN
41: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

77: l_order_number NUMBER;
78: l_user_name VARCHAR2(255); -- Bug number 6633740
79:
80: --
81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
82: --
83: -- The following sql is not needed sind the value is being passed from
84: -- the form. See bug#3631508
85: -- cursor roles is -- 3051285

Line 92: -- oe_debug_pub.Debug_On;

88: -- where display_name = p_resolving_role;
89:
90: BEGIN
91:
92: -- oe_debug_pub.Debug_On;
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'IN CREATE_CHGORDERWORKITEM' ) ;
95: oe_debug_pub.add( 'P_RESOLVING_NAME->' || p_resolving_name);
96: END IF;

Line 94: oe_debug_pub.add( 'IN CREATE_CHGORDERWORKITEM' ) ;

90: BEGIN
91:
92: -- oe_debug_pub.Debug_On;
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'IN CREATE_CHGORDERWORKITEM' ) ;
95: oe_debug_pub.add( 'P_RESOLVING_NAME->' || p_resolving_name);
96: END IF;
97:
98: -- Generate a unique item key to create a flow

Line 95: oe_debug_pub.add( 'P_RESOLVING_NAME->' || p_resolving_name);

91:
92: -- oe_debug_pub.Debug_On;
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'IN CREATE_CHGORDERWORKITEM' ) ;
95: oe_debug_pub.add( 'P_RESOLVING_NAME->' || p_resolving_name);
96: END IF;
97:
98: -- Generate a unique item key to create a flow
99: select oe_wf_key_s.nextval into l_wf_item_key

Line 103: oe_debug_pub.add( 'WF ITEM KEY IS :'|| L_WF_ITEM_KEY ) ;

99: select oe_wf_key_s.nextval into l_wf_item_key
100: from dual;
101:
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add( 'WF ITEM KEY IS :'|| L_WF_ITEM_KEY ) ;
104: END IF;
105:
106: -- retrieve the NAME from DISPLAY_NAME
107: -- The following sql is not needed sind the value is being passed from

Line 127: oe_debug_pub.add( 'PROCESS NAME IS : ' || L_PROCESS_NAME ) ;

123:
124: l_process_name := p_Workflow_Process;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'PROCESS NAME IS : ' || L_PROCESS_NAME ) ;
128: oe_debug_pub.add( 'RESOLVING ROLE IS : '|| L_RESOLVING_ROLE_NAME ) ;
129: oe_debug_pub.add( 'USER TEXT IS :' || P_USER_TEXT ) ;
130: END IF;
131:

Line 128: oe_debug_pub.add( 'RESOLVING ROLE IS : '|| L_RESOLVING_ROLE_NAME ) ;

124: l_process_name := p_Workflow_Process;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'PROCESS NAME IS : ' || L_PROCESS_NAME ) ;
128: oe_debug_pub.add( 'RESOLVING ROLE IS : '|| L_RESOLVING_ROLE_NAME ) ;
129: oe_debug_pub.add( 'USER TEXT IS :' || P_USER_TEXT ) ;
130: END IF;
131:
132: -- Create the Change Order Item

Line 129: oe_debug_pub.add( 'USER TEXT IS :' || P_USER_TEXT ) ;

125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'PROCESS NAME IS : ' || L_PROCESS_NAME ) ;
128: oe_debug_pub.add( 'RESOLVING ROLE IS : '|| L_RESOLVING_ROLE_NAME ) ;
129: oe_debug_pub.add( 'USER TEXT IS :' || P_USER_TEXT ) ;
130: END IF;
131:
132: -- Create the Change Order Item
133: WF_ENGINE.CreateProcess(l_chgord_item_type,to_char(l_wf_item_key),l_process_name);

Line 169: oe_debug_pub.add('Value of document is :' || l_document_body);

165: l_document_body := wf_engine.GetItemAttrText(l_chgord_item_type
166: , l_wf_item_key
167: , 'BOOKING_DOCUMENT');
168:
169: oe_debug_pub.add('Value of document is :' || l_document_body);
170: */
171:
172: -- Bug number 6633740
173: IF l_debug_level > 0 THEN

Line 174: oe_debug_pub.add( 'Assigning From user to workflow '|| FND_GLOBAL.USER_ID ) ;

170: */
171:
172: -- Bug number 6633740
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'Assigning From user to workflow '|| FND_GLOBAL.USER_ID ) ;
175: END IF;
176: BEGIN
177: select user_name
178: into l_user_name

Line 200: oe_debug_pub.add( 'EXITING CREATE_CHGORDERWORKITEM' ) ;

196: -- Make a call to the StartChangeOrderFlow to start the change order process
197: -- Start_ChangeOrderFlow(l_chgord_item_type, to_char(l_wf_item_key));
198:
199: IF l_debug_level > 0 THEN
200: oe_debug_pub.add( 'EXITING CREATE_CHGORDERWORKITEM' ) ;
201: END IF;
202: commit;
203: EXCEPTION
204: WHEN OTHERS THEN

Line 213: --oe_debug_pub.dumpdebug;

209: , 'Create_ChgOrderWorkItem');
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: --oe_debug_pub.dumpdebug;
214: --oe_debug_pub.Debug_Off;
215:
216: END Create_ChgOrderWorkItem;
217:

Line 214: --oe_debug_pub.Debug_Off;

210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: --oe_debug_pub.dumpdebug;
214: --oe_debug_pub.Debug_Off;
215:
216: END Create_ChgOrderWorkItem;
217:
218: -- This procedure is used to update the free form text entered by the

Line 228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

224:
225: IS
226:
227: --
228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
229: --
230: BEGIN
231:
232: -- Set The global variable to the user text entered in the UI

Line 254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

250:
251: IS
252:
253: --
254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
255: --
256: BEGIN
257:
258: -- Set The global variable to the user text entered in the UI

Line 289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

285:
286: l_user_text VARCHAR2(250);
287:
288: --
289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
290: --
291: BEGIN
292:
293: IF l_debug_level > 0 THEN

Line 294: oe_debug_pub.add( 'INSIDE GENERATE PLSQL DOC' ) ;

290: --
291: BEGIN
292:
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'INSIDE GENERATE PLSQL DOC' ) ;
295: END IF;
296: -- Set the document type based on the display type
297: p_document_type := p_display_type;
298:

Line 306: oe_debug_pub.add( 'USER TEXT IS: ' || L_USER_TEXT ) ;

302: l_user_text := wf_engine.GetItemAttrText('OECHGORD'
303: ,p_document_id
304: , 'USER_TEXT');
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'USER TEXT IS: ' || L_USER_TEXT ) ;
307: END IF;
308:
309: -- p_document := OE_CHG_ORDER_PVT.G_USER_TEXT;
310: p_document := l_user_text;

Line 312: oe_debug_pub.add( 'VALUE OF THE P_DOCUMENT IS: '|| P_DOCUMENT ) ;

308:
309: -- p_document := OE_CHG_ORDER_PVT.G_USER_TEXT;
310: p_document := l_user_text;
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add( 'VALUE OF THE P_DOCUMENT IS: '|| P_DOCUMENT ) ;
313: END IF;
314:
315: -- p_document := 'Update of Line quantity';
316:

Line 375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

371: l_new_ordered_quantity number;
372: l_latest_can_qty number ;
373:
374: --
375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
376: --
377: BEGIN
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add( 'ENTERING RECORDLINEHIST' , 1 ) ;

Line 379: oe_debug_pub.add( 'ENTERING RECORDLINEHIST' , 1 ) ;

375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
376: --
377: BEGIN
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add( 'ENTERING RECORDLINEHIST' , 1 ) ;
380: END IF;
381:
382: -- JPN: Added the G_MISS_NUM check before inserting the history record.
383: if (p_line_rec.line_id is not null AND

Line 408: oe_debug_pub.add( 'INSERTING HISTORY FOR LINE ID : '|| TO_CHAR ( P_LINE_ID ) , 5 ) ;

404: l_latest_can_qty := l_line_rec.ordered_quantity - l_new_ordered_quantity ;
405: END IF;
406: END IF;
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'INSERTING HISTORY FOR LINE ID : '|| TO_CHAR ( P_LINE_ID ) , 5 ) ;
409: END IF;
410: -- OPM 02/JUN/2000 add 3 process attributes
411: BEGIN
412: l_err_text := null;

Line 1100: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;

1096: , l_line_rec.Revrec_implicit_flag
1097: );
1098:
1099: IF l_debug_level > 0 THEN
1100: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;
1101: END IF;
1102: x_return_status := FND_API.G_RET_STS_SUCCESS;
1103: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1104: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 1109: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;

1105: -- oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1106: EXCEPTION WHEN OTHERS THEN
1107: l_err_text := substr(SQLERRM,1,74);
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1110: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1111: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1112: END IF;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis

Line 1110: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;

1106: EXCEPTION WHEN OTHERS THEN
1107: l_err_text := substr(SQLERRM,1,74);
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1110: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1111: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1112: END IF;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1114: END;

Line 1111: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;

1107: l_err_text := substr(SQLERRM,1,74);
1108: IF l_debug_level > 0 THEN
1109: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1110: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1111: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1112: END IF;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1114: END;
1115: EXCEPTION

Line 1119: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;

1115: EXCEPTION
1116: -- to fix bug 2295947
1117: WHEN NO_DATA_FOUND THEN
1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1120: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1121: END IF;
1122: NULL;
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1120: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;

1116: -- to fix bug 2295947
1117: WHEN NO_DATA_FOUND THEN
1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1120: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1121: END IF;
1122: NULL;
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;
1124: WHEN OTHERS THEN

Line 1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;

1123: x_return_status := FND_API.G_RET_STS_SUCCESS;
1124: WHEN OTHERS THEN
1125: l_err_text := substr(SQLERRM,1,74);
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1130: END IF;
1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;

1124: WHEN OTHERS THEN
1125: l_err_text := substr(SQLERRM,1,74);
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1130: END IF;
1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');

Line 1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;

1125: l_err_text := substr(SQLERRM,1,74);
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1130: END IF;
1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1133: END IF;

Line 1135: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;

1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1133: END IF;
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1136: END IF;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: END RecordLineHist;
1139:

Line 1163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1159: l_instrument_id number;
1160: l_credit_card_holder_name varchar2(10);
1161: l_credit_card_expiration_date date;
1162: --
1163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1164: --
1165: BEGIN
1166:
1167: if (p_header_rec.header_id is not null AND

Line 1177: oe_debug_pub.add( 'RECORDHEADERHIST:INSERT A ROW FOR HEADER ID : ' || TO_CHAR ( P_HEADER_ID ) ) ;

1173: (p_header_id => p_header_id
1174: );
1175: end if;
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add( 'RECORDHEADERHIST:INSERT A ROW FOR HEADER ID : ' || TO_CHAR ( P_HEADER_ID ) ) ;
1178: END IF;
1179:
1180:
1181: -- for credit card orders, only instrument id is stored for credit card number

Line 1193: oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;

1189:
1190: IF p_changed_attribute IS NOT NULL THEN
1191:
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;
1194: END IF;
1195:
1196: -- store the instrument_id in column instruemnt_id
1197: -- if credit_card_number or credit_card_code is updated.

Line 1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;

1234:
1235: END IF;
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;

Line 1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;

1235: END IF;
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1243: END IF;

Line 1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;

1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1243: END IF;
1244: END IF;

Line 1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;

1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1243: END IF;
1244: END IF;
1245:

Line 1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;

1238: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1239: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1240: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1241: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1242: oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1243: END IF;
1244: END IF;
1245:
1246:

Line 1614: oe_debug_pub.add( 'EXITING RECORDHEADERHIST' ) ;

1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1612: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1613: IF l_debug_level > 0 THEN
1614: oe_debug_pub.add( 'EXITING RECORDHEADERHIST' ) ;
1615: END IF;
1616:
1617: EXCEPTION
1618: WHEN OTHERS THEN

Line 1646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1642: ) IS
1643: l_header_scredit_rec OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1644:
1645: --
1646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1647: --
1648: BEGIN
1649:
1650: IF l_debug_level > 0 THEN

Line 1651: oe_debug_pub.add( 'ENTERING RECORDHSCREDITHIST' ) ;

1647: --
1648: BEGIN
1649:
1650: IF l_debug_level > 0 THEN
1651: oe_debug_pub.add( 'ENTERING RECORDHSCREDITHIST' ) ;
1652: END IF;
1653:
1654: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1655: if (p_header_scredit_rec.sales_credit_id is not null AND

Line 1666: oe_debug_pub.add( 'RECORDHSCREDITHIST:INSERT A ROW FOR P_HEADER_SCREDIT_ID :' || TO_CHAR ( P_HEADER_SCREDIT_ID ) ) ;

1662: x_header_scredit_rec => l_header_scredit_rec
1663: );
1664: end if;
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add( 'RECORDHSCREDITHIST:INSERT A ROW FOR P_HEADER_SCREDIT_ID :' || TO_CHAR ( P_HEADER_SCREDIT_ID ) ) ;
1667: END IF;
1668:
1669: INSERT INTO OE_SALES_CREDIT_HISTORY
1670: (

Line 1765: oe_debug_pub.add( 'EXITING RECORDHSCREDITHIST' ) ;

1761: x_return_status := FND_API.G_RET_STS_SUCCESS;
1762: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1763: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1764: IF l_debug_level > 0 THEN
1765: oe_debug_pub.add( 'EXITING RECORDHSCREDITHIST' ) ;
1766: END IF;
1767:
1768: EXCEPTION
1769: WHEN OTHERS THEN

Line 1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1792: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1793: ) IS
1794: l_line_scredit_rec OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1795: --
1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1797: --
1798: BEGIN
1799: IF l_debug_level > 0 THEN
1800: oe_debug_pub.add( 'ENTERING RECORDLSCREDITHIST' ) ;

Line 1800: oe_debug_pub.add( 'ENTERING RECORDLSCREDITHIST' ) ;

1796: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1797: --
1798: BEGIN
1799: IF l_debug_level > 0 THEN
1800: oe_debug_pub.add( 'ENTERING RECORDLSCREDITHIST' ) ;
1801: END IF;
1802:
1803: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1804: if (p_line_scredit_rec.sales_credit_id is not null AND

Line 1815: oe_debug_pub.add( 'RECORDLSCREDITHIST:INSERT A ROW FOR P_LINE_SCREDIT_ID :' || TO_CHAR ( P_LINE_SCREDIT_ID ) ) ;

1811: x_line_scredit_rec => l_line_scredit_rec
1812: );
1813: end if;
1814: IF l_debug_level > 0 THEN
1815: oe_debug_pub.add( 'RECORDLSCREDITHIST:INSERT A ROW FOR P_LINE_SCREDIT_ID :' || TO_CHAR ( P_LINE_SCREDIT_ID ) ) ;
1816: END IF;
1817:
1818:
1819: INSERT INTO OE_SALES_CREDIT_HISTORY

Line 1916: oe_debug_pub.add( 'EXITING RECORDLSCREDITHIST' ) ;

1912: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1913: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add( 'EXITING RECORDLSCREDITHIST' ) ;
1917: END IF;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN

Line 1947: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1943: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1944: ) IS
1945: l_header_adj_rec OE_ORDER_PUB.HEADER_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
1946: --
1947: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1948: --
1949: BEGIN
1950:
1951: IF l_debug_level > 0 THEN

Line 1952: oe_debug_pub.add( 'ENTERING RECORDHPADJHIST' ) ;

1948: --
1949: BEGIN
1950:
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'ENTERING RECORDHPADJHIST' ) ;
1953: END IF;
1954:
1955: if (p_header_adj_rec.price_adjustment_id is not null AND
1956: p_header_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then

Line 1966: oe_debug_pub.add( 'RECORDHPADJHIST:INSERT A ROW FOR P_HEADER_ADJ_ID :' || TO_CHAR ( P_HEADER_ADJ_ID ) ) ;

1962: x_header_adj_rec => l_header_adj_rec
1963: );
1964: end if;
1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'RECORDHPADJHIST:INSERT A ROW FOR P_HEADER_ADJ_ID :' || TO_CHAR ( P_HEADER_ADJ_ID ) ) ;
1967: END IF;
1968:
1969: INSERT INTO OE_PRICE_ADJS_HISTORY
1970: (

Line 2197: oe_debug_pub.add( 'EXITING RECORD HEADER ADJUSTMENTS HISTORY ' , 5 ) ;

2193: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2194: x_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: IF l_debug_level > 0 THEN
2197: oe_debug_pub.add( 'EXITING RECORD HEADER ADJUSTMENTS HISTORY ' , 5 ) ;
2198: END IF;
2199:
2200: EXCEPTION
2201: WHEN OTHERS THEN

Line 2228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2224: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
2225: ) IS
2226: l_line_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
2227: --
2228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2229: --
2230: BEGIN
2231:
2232: IF l_debug_level > 0 THEN

Line 2233: oe_debug_pub.add( 'ENTERING RECORDLPADJHIST' ) ;

2229: --
2230: BEGIN
2231:
2232: IF l_debug_level > 0 THEN
2233: oe_debug_pub.add( 'ENTERING RECORDLPADJHIST' ) ;
2234: END IF;
2235:
2236: -- JPN: Added the G_MISS_NUM check before inserting the history record.
2237: if (p_line_adj_rec.price_adjustment_id is not null AND

Line 2248: oe_debug_pub.add( 'RECORDLPADJHIST:INSERT A ROW FOR P_LINE_ADJ_ID :' || TO_CHAR ( P_LINE_ADJ_ID ) ) ;

2244: x_line_adj_rec => l_line_adj_rec);
2245: end if;
2246:
2247: IF l_debug_level > 0 THEN
2248: oe_debug_pub.add( 'RECORDLPADJHIST:INSERT A ROW FOR P_LINE_ADJ_ID :' || TO_CHAR ( P_LINE_ADJ_ID ) ) ;
2249: END IF;
2250:
2251: INSERT INTO OE_PRICE_ADJS_HISTORY
2252: (

Line 2482: oe_debug_pub.add( 'EXITING AFTER INSERTING LINE PRICE ADJUSTMENTS HISTORY' , 5 ) ;

2478: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2479: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2480: x_return_status := FND_API.G_RET_STS_SUCCESS;
2481: IF l_debug_level > 0 THEN
2482: oe_debug_pub.add( 'EXITING AFTER INSERTING LINE PRICE ADJUSTMENTS HISTORY' , 5 ) ;
2483: END IF;
2484:
2485: EXCEPTION
2486: WHEN OTHERS THEN

Line 2501: OE_DEBUG_PUB.add('Reason Required Flag has been reset to N',1);

2497: BEGIN
2498: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2499: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2500: OE_GLOBALS.OE_AUDIT_HISTORY_TBL.delete;
2501: OE_DEBUG_PUB.add('Reason Required Flag has been reset to N',1);
2502: END Reset_Audit_History_Flags;
2503:
2504: END OE_CHG_ORDER_PVT;