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 1118: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;

1114: , l_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
1115: );
1116:
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;
1119: END IF;
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1122: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

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

1123: -- oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1124: EXCEPTION 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( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1129: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1130: END IF;
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis

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

1124: EXCEPTION 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( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1129: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1130: END IF;
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1132: END;

Line 1129: oe_debug_pub.add( 'IN INNER EXCEPTION' , 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( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1129: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1130: END IF;
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1132: END;
1133: EXCEPTION

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

1133: EXCEPTION
1134: -- to fix bug 2295947
1135: WHEN NO_DATA_FOUND THEN
1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1138: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1139: END IF;
1140: NULL;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1134: -- to fix bug 2295947
1135: WHEN NO_DATA_FOUND THEN
1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1138: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1139: END IF;
1140: NULL;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142: WHEN OTHERS THEN

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

1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142: WHEN OTHERS THEN
1143: l_err_text := substr(SQLERRM,1,74);
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1146: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1147: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1148: END IF;
1149: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1142: WHEN OTHERS THEN
1143: l_err_text := substr(SQLERRM,1,74);
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1146: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1147: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1148: END IF;
1149: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1150: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');

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

1143: l_err_text := substr(SQLERRM,1,74);
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1146: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1147: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1148: END IF;
1149: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1150: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1151: END IF;

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

1149: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1150: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1151: END IF;
1152: IF l_debug_level > 0 THEN
1153: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1154: END IF;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: END RecordLineHist;
1157:

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

1177: l_instrument_id number;
1178: l_credit_card_holder_name varchar2(10);
1179: l_credit_card_expiration_date date;
1180: --
1181: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1182: --
1183: BEGIN
1184:
1185: if (p_header_rec.header_id is not null AND

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

1191: (p_header_id => p_header_id
1192: );
1193: end if;
1194: IF l_debug_level > 0 THEN
1195: oe_debug_pub.add( 'RECORDHEADERHIST:INSERT A ROW FOR HEADER ID : ' || TO_CHAR ( P_HEADER_ID ) ) ;
1196: END IF;
1197:
1198:
1199: -- for credit card orders, only instrument id is stored for credit card number

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

1207:
1208: IF p_changed_attribute IS NOT NULL THEN
1209:
1210: IF l_debug_level > 0 THEN
1211: oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;
1212: END IF;
1213:
1214: -- store the instrument_id in column instruemnt_id
1215: -- if credit_card_number or credit_card_code is updated.

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

1252:
1253: END IF;
1254:
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1257: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1258: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1259: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1260: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;

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

1253: END IF;
1254:
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1257: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1258: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1259: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1260: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1261: END IF;

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

1254:
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1257: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1258: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1259: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1260: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1261: END IF;
1262: END IF;

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

1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1257: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1258: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1259: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1260: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1261: END IF;
1262: END IF;
1263:

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

1256: oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
1257: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_code is : ' || l_credit_card_code) ;
1258: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_number is : ' || l_credit_card_number) ;
1259: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_holder_name is : ' || l_credit_card_holder_name) ;
1260: --oe_debug_pub.add( 'RECORDHEADERHIST:l_credit_card_expiration_date is : ' || l_credit_card_expiration_date) ;
1261: END IF;
1262: END IF;
1263:
1264:

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

1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1630: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1631: IF l_debug_level > 0 THEN
1632: oe_debug_pub.add( 'EXITING RECORDHEADERHIST' ) ;
1633: END IF;
1634:
1635: EXCEPTION
1636: WHEN OTHERS THEN

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

1660: ) IS
1661: l_header_scredit_rec OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC;
1662:
1663: --
1664: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1665: --
1666: BEGIN
1667:
1668: IF l_debug_level > 0 THEN

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

1665: --
1666: BEGIN
1667:
1668: IF l_debug_level > 0 THEN
1669: oe_debug_pub.add( 'ENTERING RECORDHSCREDITHIST' ) ;
1670: END IF;
1671:
1672: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1673: if (p_header_scredit_rec.sales_credit_id is not null AND

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

1680: x_header_scredit_rec => l_header_scredit_rec
1681: );
1682: end if;
1683: IF l_debug_level > 0 THEN
1684: oe_debug_pub.add( 'RECORDHSCREDITHIST:INSERT A ROW FOR P_HEADER_SCREDIT_ID :' || TO_CHAR ( P_HEADER_SCREDIT_ID ) ) ;
1685: END IF;
1686:
1687: INSERT INTO OE_SALES_CREDIT_HISTORY
1688: (

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

1779: x_return_status := FND_API.G_RET_STS_SUCCESS;
1780: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1781: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1782: IF l_debug_level > 0 THEN
1783: oe_debug_pub.add( 'EXITING RECORDHSCREDITHIST' ) ;
1784: END IF;
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN

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

1810: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1811: ) IS
1812: l_line_scredit_rec OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE := OE_Order_PUB.G_MISS_LINE_SCREDIT_REC;
1813: --
1814: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1815: --
1816: BEGIN
1817: IF l_debug_level > 0 THEN
1818: oe_debug_pub.add( 'ENTERING RECORDLSCREDITHIST' ) ;

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

1814: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1815: --
1816: BEGIN
1817: IF l_debug_level > 0 THEN
1818: oe_debug_pub.add( 'ENTERING RECORDLSCREDITHIST' ) ;
1819: END IF;
1820:
1821: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1822: if (p_line_scredit_rec.sales_credit_id is not null AND

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

1829: x_line_scredit_rec => l_line_scredit_rec
1830: );
1831: end if;
1832: IF l_debug_level > 0 THEN
1833: oe_debug_pub.add( 'RECORDLSCREDITHIST:INSERT A ROW FOR P_LINE_SCREDIT_ID :' || TO_CHAR ( P_LINE_SCREDIT_ID ) ) ;
1834: END IF;
1835:
1836:
1837: INSERT INTO OE_SALES_CREDIT_HISTORY

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

1930: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1931: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933: IF l_debug_level > 0 THEN
1934: oe_debug_pub.add( 'EXITING RECORDLSCREDITHIST' ) ;
1935: END IF;
1936:
1937: EXCEPTION
1938: WHEN OTHERS THEN

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

1961: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1962: ) IS
1963: l_header_adj_rec OE_ORDER_PUB.HEADER_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
1964: --
1965: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1966: --
1967: BEGIN
1968:
1969: IF l_debug_level > 0 THEN

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

1966: --
1967: BEGIN
1968:
1969: IF l_debug_level > 0 THEN
1970: oe_debug_pub.add( 'ENTERING RECORDHPADJHIST' ) ;
1971: END IF;
1972:
1973: if (p_header_adj_rec.price_adjustment_id is not null AND
1974: p_header_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then

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

1980: x_header_adj_rec => l_header_adj_rec
1981: );
1982: end if;
1983: IF l_debug_level > 0 THEN
1984: oe_debug_pub.add( 'RECORDHPADJHIST:INSERT A ROW FOR P_HEADER_ADJ_ID :' || TO_CHAR ( P_HEADER_ADJ_ID ) ) ;
1985: END IF;
1986:
1987: INSERT INTO OE_PRICE_ADJS_HISTORY
1988: (

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

2211: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2212: x_return_status := FND_API.G_RET_STS_SUCCESS;
2213:
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'EXITING RECORD HEADER ADJUSTMENTS HISTORY ' , 5 ) ;
2216: END IF;
2217:
2218: EXCEPTION
2219: WHEN OTHERS THEN

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

2242: ,x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
2243: ) IS
2244: l_line_adj_rec OE_ORDER_PUB.LINE_ADJ_REC_TYPE := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
2245: --
2246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2247: --
2248: BEGIN
2249:
2250: IF l_debug_level > 0 THEN

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

2247: --
2248: BEGIN
2249:
2250: IF l_debug_level > 0 THEN
2251: oe_debug_pub.add( 'ENTERING RECORDLPADJHIST' ) ;
2252: END IF;
2253:
2254: -- JPN: Added the G_MISS_NUM check before inserting the history record.
2255: if (p_line_adj_rec.price_adjustment_id is not null AND

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

2262: x_line_adj_rec => l_line_adj_rec);
2263: end if;
2264:
2265: IF l_debug_level > 0 THEN
2266: oe_debug_pub.add( 'RECORDLPADJHIST:INSERT A ROW FOR P_LINE_ADJ_ID :' || TO_CHAR ( P_LINE_ADJ_ID ) ) ;
2267: END IF;
2268:
2269: INSERT INTO OE_PRICE_ADJS_HISTORY
2270: (

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

2496: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2497: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2498: x_return_status := FND_API.G_RET_STS_SUCCESS;
2499: IF l_debug_level > 0 THEN
2500: oe_debug_pub.add( 'EXITING AFTER INSERTING LINE PRICE ADJUSTMENTS HISTORY' , 5 ) ;
2501: END IF;
2502:
2503: EXCEPTION
2504: WHEN OTHERS THEN

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

2515: BEGIN
2516: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2517: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2518: OE_GLOBALS.OE_AUDIT_HISTORY_TBL.delete;
2519: OE_DEBUG_PUB.add('Reason Required Flag has been reset to N',1);
2520: END Reset_Audit_History_Flags;
2521:
2522: END OE_CHG_ORDER_PVT;