181:
182: END;
183:
184: PROCEDURE Update_Msg_Context (
185: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
182: END;
183:
184: PROCEDURE Update_Msg_Context (
185: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
183:
184: PROCEDURE Update_Msg_Context (
185: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
184: PROCEDURE Update_Msg_Context (
185: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
185: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
186: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
187: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
188: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
189: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
197: ) IS
190: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
197: ) IS
198: --
191: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
197: ) IS
198: --
199: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
192: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
193: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
194: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
195: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
196: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
197: ) IS
198: --
199: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
200: --
199: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
200: --
201: Begin
202:
203: if p_entity_id <> FND_API.G_MISS_NUM then
204: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
205: end if;
206: if p_header_id <> FND_API.G_MISS_NUM then
207: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
202:
203: if p_entity_id <> FND_API.G_MISS_NUM then
204: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
205: end if;
206: if p_header_id <> FND_API.G_MISS_NUM then
207: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
208: end if;
209: if p_line_id <> FND_API.G_MISS_NUM then
210: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
205: end if;
206: if p_header_id <> FND_API.G_MISS_NUM then
207: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
208: end if;
209: if p_line_id <> FND_API.G_MISS_NUM then
210: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
211: end if;
212: if p_order_source_id <> FND_API.G_MISS_NUM then
213: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
208: end if;
209: if p_line_id <> FND_API.G_MISS_NUM then
210: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
211: end if;
212: if p_order_source_id <> FND_API.G_MISS_NUM then
213: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
214: end if;
215: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
216: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
211: end if;
212: if p_order_source_id <> FND_API.G_MISS_NUM then
213: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
214: end if;
215: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
216: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
217: end if;
218: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
219: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
214: end if;
215: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
216: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
217: end if;
218: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
219: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
220: end if;
221: if p_source_document_type_id <> FND_API.G_MISS_NUM then
222: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
217: end if;
218: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
219: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
220: end if;
221: if p_source_document_type_id <> FND_API.G_MISS_NUM then
222: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
223: end if;
224: if p_source_document_id <> FND_API.G_MISS_NUM then
225: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
220: end if;
221: if p_source_document_type_id <> FND_API.G_MISS_NUM then
222: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
223: end if;
224: if p_source_document_id <> FND_API.G_MISS_NUM then
225: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
226: end if;
227: if p_source_document_line_id <> FND_API.G_MISS_NUM then
228: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
223: end if;
224: if p_source_document_id <> FND_API.G_MISS_NUM then
225: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
226: end if;
227: if p_source_document_line_id <> FND_API.G_MISS_NUM then
228: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
229: end if;
230: if p_attribute_code <> FND_API.G_MISS_CHAR then
231: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
226: end if;
227: if p_source_document_line_id <> FND_API.G_MISS_NUM then
228: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
229: end if;
230: if p_attribute_code <> FND_API.G_MISS_CHAR then
231: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
232: end if;
233: if p_constraint_id <> FND_API.G_MISS_NUM then
234: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;
229: end if;
230: if p_attribute_code <> FND_API.G_MISS_CHAR then
231: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
232: end if;
233: if p_constraint_id <> FND_API.G_MISS_NUM then
234: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;
235: end if;
236:
237: End Update_Msg_Context;
262:
263: END Count_Msg;
264:
265: PROCEDURE Count_And_Get
266: ( p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
267: p_count OUT NOCOPY NUMBER ,
268:
269: p_data OUT NOCOPY VARCHAR2
270:
486: END Delete_Msg;
487:
488: PROCEDURE Get
489: ( p_msg_index IN NUMBER := G_NEXT ,
490: p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
491: p_data OUT NOCOPY VARCHAR2 ,
492:
493: p_msg_index_out OUT NOCOPY NUMBER
494:
520: oe_debug_pub.add( 'ENTERING THE MESSAGE_TEXT NOT NULL' ) ;
521: END IF;
522:
523: ELSE
524: IF FND_API.To_Boolean( p_encoded ) THEN
525:
526: p_data := G_msg_tbl.Message( G_msg_index );
527: IF l_debug_level > 0 THEN
528: oe_debug_pub.add( 'ENTERING P_ENCODED AS TRUE ' ) ;
557: END Get;
558:
559: FUNCTION Get
560: ( p_msg_index IN NUMBER := G_NEXT ,
561: p_encoded IN VARCHAR2 := FND_API.G_TRUE
562: )
563: RETURN VARCHAR2
564: IS
565: l_data VARCHAR2(2000) ;
620: p_PROCEDURE_name => l_procedure_name ,
621: p_error_text => 'Invalid p_mode: '||p_mode
622: );
623:
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625:
626: END IF;
627:
628: END Reset;
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: --
652: BEGIN
653:
654: IF G_msg_level_threshold = FND_API.G_MISS_NUM THEN
655:
656: -- Read the Profile option value.
657:
658: G_msg_level_threshold :=
670:
671: END; -- Check_Msg_Level
672:
673: PROCEDURE Build_Exc_Msg
674: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
675: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
676: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
677: )
678: IS
671: END; -- Check_Msg_Level
672:
673: PROCEDURE Build_Exc_Msg
674: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
675: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
676: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
677: )
678: IS
679: l_error_text VARCHAR2(2000) := p_error_text ;
672:
673: PROCEDURE Build_Exc_Msg
674: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
675: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
676: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
677: )
678: IS
679: l_error_text VARCHAR2(2000) := p_error_text ;
680: --
683: BEGIN
684:
685: -- If p_error_text is missing use SQLERRM.
686:
687: IF p_error_text = FND_API.G_MISS_CHAR THEN
688:
689: l_error_text := SUBSTR (SQLERRM , 1 , 2000);
690:
691: END IF;
691: END IF;
692:
693: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
694:
695: IF p_pkg_name <> FND_API.G_MISS_CHAR THEN
696: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_pkg_name);
697: END IF;
698:
699: IF p_PROCEDURE_name <> FND_API.G_MISS_CHAR THEN
695: IF p_pkg_name <> FND_API.G_MISS_CHAR THEN
696: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_pkg_name);
697: END IF;
698:
699: IF p_PROCEDURE_name <> FND_API.G_MISS_CHAR THEN
700: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure_name);
701: END IF;
702:
703: IF l_error_text <> FND_API.G_MISS_CHAR THEN
699: IF p_PROCEDURE_name <> FND_API.G_MISS_CHAR THEN
700: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure_name);
701: END IF;
702:
703: IF l_error_text <> FND_API.G_MISS_CHAR THEN
704: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
705: END IF;
706:
707: END; -- Build_Exc_Msg
706:
707: END; -- Build_Exc_Msg
708:
709: PROCEDURE Add_Exc_Msg
710: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
711: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
712: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
713: p_context_flag IN VARCHAR2 DEFAULT 'Y'
714: )
707: END; -- Build_Exc_Msg
708:
709: PROCEDURE Add_Exc_Msg
710: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
711: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
712: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
713: p_context_flag IN VARCHAR2 DEFAULT 'Y'
714: )
715: IS
708:
709: PROCEDURE Add_Exc_Msg
710: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
711: p_PROCEDURE_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
712: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
713: p_context_flag IN VARCHAR2 DEFAULT 'Y'
714: )
715: IS
716: --