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.EDR_STANDARD_PUB dependencies on STANDARD

Line 1: PACKAGE BODY edr_standard_pub AS

1: PACKAGE BODY edr_standard_pub AS
2: /* $Header: EDRPSTDB.pls 120.0.12000000.1 2007/01/18 05:54:50 appldev ship $ */
3:
4: -- globle variables
5: G_PKG_NAME CONSTANT VARCHAR2(100) := 'EDR_STANDARD_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(100) := 'EDR_STANDARD_PUB';

1: PACKAGE BODY edr_standard_pub AS
2: /* $Header: EDRPSTDB.pls 120.0.12000000.1 2007/01/18 05:54:50 appldev ship $ */
3:
4: -- globle variables
5: G_PKG_NAME CONSTANT VARCHAR2(100) := 'EDR_STANDARD_PUB';
6:
7:
8:
9: -- --------------------------------------

Line 19: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status

15: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
16: -- p_event_key VARCHAR2 event key, eg ItemNo3125
17: -- OUT : x_psig_status VARCHAR2 event psig status,
18: -- null: no data found, SQLERROR: exception in callee
19: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status
20: -- ---------------------------------------
21:
22: PROCEDURE Get_PsigStatus (
23: p_api_version IN NUMBER,

Line 35: -- Standard call to check for call compatibility

31: IS
32: l_api_version CONSTANT NUMBER := 1.0;
33: l_api_name CONSTANT VARCHAR2(50) := 'Get_PsigStatus';
34: BEGIN
35: -- Standard call to check for call compatibility
36: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
37: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:

Line 48: edr_standard.Psig_Status(

44:
45: -- Initialize API return status to success
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: edr_standard.Psig_Status(
49: P_EVENT => p_event_name,
50: P_EVENT_KEY => p_event_key,
51: P_STATUS => x_psig_status );
52:

Line 53: -- Standard call to get message count, and if count is 1, get message info

49: P_EVENT => p_event_name,
50: P_EVENT_KEY => p_event_key,
51: P_STATUS => x_psig_status );
52:
53: -- Standard call to get message count, and if count is 1, get message info
54: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN

Line 81: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_REQUIRED

77: -- Parameters
78: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
79: -- p_event_key VARCHAR2 event key, eg ItemNo3125
80: -- OUT : x_psig_required VARCHAR2 event psig status
81: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_REQUIRED
82: -- ---------------------------------------
83:
84: PROCEDURE Is_eSig_Required (
85: p_api_version IN NUMBER,

Line 98: -- Standard call to check for call compatibility

94: l_api_version CONSTANT NUMBER := 1.0;
95: l_api_name CONSTANT VARCHAR2(50) := 'Is_Psig_Required';
96: l_isRequired BOOLEAN;
97: BEGIN
98: -- Standard call to check for call compatibility
99: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
100: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:

Line 112: edr_standard.Psig_Required(

108: -- Initialize API return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: BEGIN
112: edr_standard.Psig_Required(
113: P_EVENT => p_event_name,
114: P_EVENT_KEY => p_event_key,
115: P_STATUS => l_isRequired );
116: IF l_isRequired THEN x_isRequired_eSig := FND_API.G_TRUE;

Line 130: -- Standard call to get message count, and if count is 1, get message info

126: -- would only add the last one message in the above api call
127: -- need to do this in the above api after each fnd_message.set_name/set_token
128: FND_MSG_PUB.Add;
129:
130: -- Standard call to get message count, and if count is 1, get message info
131: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN

Line 158: -- Versions : 1.0 17-Jul-03 created from edr_standard.EREC_REQUIRED

154: -- Parameters
155: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
156: -- p_event_key VARCHAR2 event key, eg ItemNo3125
157: -- OUT : x_erec_required VARCHAR2 event psig status
158: -- Versions : 1.0 17-Jul-03 created from edr_standard.EREC_REQUIRED
159: -- ---------------------------------------
160:
161: PROCEDURE Is_eRec_Required (
162: p_api_version IN NUMBER,

Line 175: -- Standard call to check for call compatibility

171: l_api_version CONSTANT NUMBER := 1.0;
172: l_api_name CONSTANT VARCHAR2(50) := 'Is_Erec_Required';
173: l_isRequired BOOLEAN;
174: BEGIN
175: -- Standard call to check for call compatibility
176: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
177: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:

Line 189: edr_standard.Erec_Required(

185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: BEGIN
189: edr_standard.Erec_Required(
190: P_EVENT => p_event_name,
191: P_EVENT_KEY => p_event_key,
192: P_STATUS => l_isRequired );
193: IF l_isRequired THEN x_isRequired_eRec := FND_API.G_TRUE;

Line 207: -- Standard call to get message count, and if count is 1, get message info

203: -- would only add the last one message in the above api call
204: -- need to do this in the above api after each fnd_message.set_name/set_token
205: FND_MSG_PUB.Add;
206:
207: -- Standard call to get message count, and if count is 1, get message info
208: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN

Line 235: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_QUERY

231: -- Parameters
232: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
233: -- p_event_key VARCHAR2 event key, eg ItemNo3125
234: -- OUT : x_psig_status VARCHAR2 event psig status
235: -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_QUERY
236: -- ---------------------------------------
237:
238: Procedure Get_QueryId_OnEvents (
239: p_api_version IN NUMBER,

Line 250: l_eventDetl_tbl edr_standard.eventQuery;

246: x_query_id OUT NOCOPY NUMBER )
247: IS
248: l_api_version CONSTANT NUMBER := 1.0;
249: l_api_name CONSTANT VARCHAR2(50) := 'Get_QueryId_OnEvents';
250: l_eventDetl_tbl edr_standard.eventQuery;
251: lth NUMBER;
252: BEGIN
253: -- Standard call to check for call compatibility
254: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )

Line 253: -- Standard call to check for call compatibility

249: l_api_name CONSTANT VARCHAR2(50) := 'Get_QueryId_OnEvents';
250: l_eventDetl_tbl edr_standard.eventQuery;
251: lth NUMBER;
252: BEGIN
253: -- Standard call to check for call compatibility
254: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
255: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257:

Line 269: x_query_id := edr_standard.Psig_Query ( l_eventDetl_tbl );

265:
266: FOR lth in 1..p_eventQuery_recTbl.COUNT LOOP
267: l_eventDetl_tbl(lth) := p_eventQuery_recTbl(lth);
268: END LOOP;
269: x_query_id := edr_standard.Psig_Query ( l_eventDetl_tbl );
270:
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;

Line 274: -- Standard call to get message count, and if count is 1, get message info

270:
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count, and if count is 1, get message info
275: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN

Line 306: -- Versions : 1.0 17-Jul-03 created from edr_standard.DISPLAY_DATE

302: -- OUT : x_return_status VARCHAR2
303: -- x_msg_count NUMBER
304: -- x_msg_data VARCHAR2
305: -- x_date_out VARCHAR2 converted date
306: -- Versions : 1.0 17-Jul-03 created from edr_standard.DISPLAY_DATE
307: -- ---------------------------------------
308:
309: PROCEDURE Display_Date (
310: p_api_version IN NUMBER,

Line 331: edr_standard.Display_Date ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );

327: END IF;
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: edr_standard.Display_Date ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
332:
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN

Line 363: -- Versions : 1.0 07-Nov-03 created from edr_standard.DISPLAY_DATE_ONLY

359: -- OUT : x_return_status VARCHAR2
360: -- x_msg_count NUMBER
361: -- x_msg_data VARCHAR2
362: -- x_date_out VARCHAR2 converted date
363: -- Versions : 1.0 07-Nov-03 created from edr_standard.DISPLAY_DATE_ONLY
364: -- ---------------------------------------
365:
366: PROCEDURE Display_Date_Only (
367: p_api_version IN NUMBER,

Line 388: edr_standard.Display_Date_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );

384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: edr_standard.Display_Date_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
389:
390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN

Line 420: -- Versions : 1.0 12-Nov-03 created from edr_standard.DISPLAY_TIME_ONLY

416: -- OUT : x_return_status VARCHAR2
417: -- x_msg_count NUMBER
418: -- x_msg_data VARCHAR2
419: -- x_date_out VARCHAR2 converted time
420: -- Versions : 1.0 12-Nov-03 created from edr_standard.DISPLAY_TIME_ONLY
421: -- ---------------------------------------
422:
423: PROCEDURE Display_Time_Only (
424: p_api_version IN NUMBER,

Line 445: edr_standard.Display_Time_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );

441: END IF;
442:
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: edr_standard.Display_Time_Only ( P_DATE_IN => p_date_in, P_DATE_OUT => x_date_out );
446:
447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN

Line 474: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_AMERULE_INPUT_VALUES

470: -- IN : p_transaction_name VARCHAR2 transaction name, eg GMI ERES Item Creation
471: -- p_ameRule_id NUMBER AME rule id, eg 11400
472: -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
473: -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
474: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_AMERULE_INPUT_VALUES
475: -- ---------------------------------------
476:
477: -- Bug 3214495 : Start
478:

Line 494: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;

490: x_inputVar_values_tbl OUT NOCOPY InputVar_Values_tbl_type )
491: IS
492: l_api_name CONSTANT VARCHAR2(50) := 'Get_AmeRule_VarValues';
493: l_api_version CONSTANT NUMBER := 1.0;
494: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
495: lth NUMBER;
496: BEGIN
497: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
498: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 507: edr_standard.GET_AMERULE_INPUT_VALUES (

503: END IF;
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: edr_standard.GET_AMERULE_INPUT_VALUES (
508: ameapplication => p_transaction_name,
509: ameruleid => p_ameRule_id,
510: amerulename => p_ameRule_name,
511: ameruleinputvalues => l_ruleVar_values );

Line 545: -- Versions : 1.0 19-Feb-05 created from edr_standard.GET_AMERULE_INPUT_VARIABLES

541: -- IN : p_transaction_id VARCHAR2 transaction id, eg oracle.apps.gme.item.create
542: -- p_ameRule_id NUMBER AME rule id, eg 11400
543: -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
544: -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
545: -- Versions : 1.0 19-Feb-05 created from edr_standard.GET_AMERULE_INPUT_VARIABLES
546: -- ---------------------------------------
547:
548:
549: PROCEDURE Get_AmeRule_VariableValues (

Line 562: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;

558: x_inputVar_values_tbl OUT NOCOPY InputVar_Values_tbl_type )
559: IS
560: l_api_name CONSTANT VARCHAR2(50) := 'Get_AmeRule_VarValues';
561: l_api_version CONSTANT NUMBER := 1.0;
562: l_ruleVar_values EDR_STANDARD.ameruleinputvalues;
563: lth NUMBER;
564: BEGIN
565: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
566: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 575: edr_standard.GET_AMERULE_INPUT_VARIABLES (

571: END IF;
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: edr_standard.GET_AMERULE_INPUT_VARIABLES (
576: transactiontypeid => p_transaction_id,
577: ameruleid => p_ameRule_id,
578: amerulename => p_ameRule_name,
579: ameruleinputvalues => l_ruleVar_values );

Line 615: -- Versions : 1.0 17-Jul-03 created from edr_standard.COMPARE_AUDITVALUES

611: -- p_column_name VARCHAR2 column to be checked, eg ItemNo3125
612: -- p_primKey_name VARCHAR2 name of primary key, eg ItemNo3125
613: -- p_primKey_value VARCHAR2 value of primary key, eg ItemNo3125
614: -- OUT : x_auditValue_old VARCHAR2 indicate if the audited value is updated
615: -- Versions : 1.0 17-Jul-03 created from edr_standard.COMPARE_AUDITVALUES
616: -- ---------------------------------------
617:
618: Procedure Is_AuditValue_Old (
619: p_api_version IN NUMBER,

Line 634: -- Standard call to check for call compatibility

630: l_api_version CONSTANT NUMBER := 1.0;
631: l_api_name CONSTANT VARCHAR2(50) := 'Is_AuditValue_Old';
632: l_isAudited VARCHAR2(10);
633: BEGIN
634: -- Standard call to check for call compatibility
635: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
636: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:

Line 648: l_isAudited := edr_standard.Compare_AuditValues ( p_table_name,

644: -- Initialize API return status to success
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: BEGIN
648: l_isAudited := edr_standard.Compare_AuditValues ( p_table_name,
649: p_column_name, p_primKey_name, p_primKey_value );
650: IF l_isAudited = 'true' THEN x_isOld_auditValue := FND_API.G_TRUE;
651: ELSE x_isOld_auditValue := FND_API.G_FALSE;
652: END IF;

Line 665: -- Standard call to get message count, and if count is 1, get message info

661: -- would only add the last one message in the above api call
662: -- need to do this in the above api after each fnd_message.set_name/set_token
663: FND_MSG_PUB.Add;
664:
665: -- Standard call to get message count, and if count is 1, get message info
666: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN

Line 695: -- Versions : 1.0 17-Jul-03 created from edr_standard.FIND_WF_NTF_RECIPIENT

691: -- p_message_type VARCHAR2 message type
692: -- p_message_name VARCHAR2 message name
693: -- OUT : x_final_recipient VARCHAR2 final recipient
694: -- x_allrout_comments VARCHAR2 all routing comments
695: -- Versions : 1.0 17-Jul-03 created from edr_standard.FIND_WF_NTF_RECIPIENT
696: -- ---------------------------------------
697:
698: PROCEDURE Get_Notif_Routing_Info (
699: p_api_version IN NUMBER,

Line 727: edr_standard.FIND_WF_NTF_RECIPIENT(

723:
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: BEGIN
727: edr_standard.FIND_WF_NTF_RECIPIENT(
728: P_ORIGINAL_RECIPIENT => p_original_recipient,
729: P_MESSAGE_TYPE => p_message_type,
730: P_MESSAGE_NAME => p_message_name,
731: P_RECIPIENT => x_final_recipient,

Line 783: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_SINGLE_PROMPT

779: -- p_column_name VARCHAR2 name of the column corresponding to a flex segment
780: -- p_prompt_type VARCHAR2 indicate the field from which to return values
781: -- 'LEFT' --> FORM_LEFT_PROMPT; 'ABOVE' --> FORM_ABOVE_PROMPT
782: -- OUT : x_column_prompt VARCHAR2 the prompt values for the columns
783: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_SINGLE_PROMPT
784: -- ---------------------------------------
785:
786: PROCEDURE Get_DescFlex_OnePrompt (
787: p_api_version IN NUMBER,

Line 803: -- Standard call to check for call compatibility

799: l_api_version CONSTANT NUMBER := 1.0;
800: l_api_name CONSTANT VARCHAR2(50) := 'Get_DescFlex_OnePrompt';
801: l_prompt_type VARCHAR2(20);
802: BEGIN
803: -- Standard call to check for call compatibility
804: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
805: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:

Line 821: edr_standard.Get_Desc_Flex_Single_Prompt (

817: l_prompt_type := 'LEFT';
818: ELSE l_prompt_type := p_prompt_type;
819: END IF;
820:
821: edr_standard.Get_Desc_Flex_Single_Prompt (
822: P_APPLICATION_ID => p_application_id ,
823: P_DESC_FLEX_DEF_NAME => p_descFlex_defName ,
824: P_DESC_FLEX_CONTEXT => p_descFlex_context ,
825: P_COLUMN_NAME => P_COLUMN_NAME ,

Line 829: -- Standard call to get message count, and if count is 1, get message info

825: P_COLUMN_NAME => P_COLUMN_NAME ,
826: P_PROMPT_TYPE => l_prompt_type ,
827: P_COLUMN_PROMPT => x_column_prompt );
828:
829: -- Standard call to get message count, and if count is 1, get message info
830: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN

Line 863: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_ALL_PROMPTS

859: -- p_prompt_type VARCHAR2 indicate the field from which to return values
860: -- 'LEFT': FORM_LEFT_PROMPT; 'ABOVE': FORM_ABOVE_PROMPT
861: -- OUT : x_colnPrompts_rec Flex_ColnPrompt_Rec_Type
862: -- the prompt values for the columns
863: -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_ALL_PROMPTS
864: -- ---------------------------------------
865:
866: PROCEDURE Get_DescFlex_AllPrompts (
867: p_api_version IN NUMBER,

Line 875: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,

871: x_msg_data OUT NOCOPY VARCHAR2,
872: p_application_id IN NUMBER,
873: p_descFlex_defName IN VARCHAR2,
874: p_descFlex_context IN VARCHAR2,
875: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,
876: p_prompt_type IN VARCHAR2,
877: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type )
878: IS
879: l_api_version CONSTANT NUMBER := 1.0;

Line 877: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type )

873: p_descFlex_defName IN VARCHAR2,
874: p_descFlex_context IN VARCHAR2,
875: p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,
876: p_prompt_type IN VARCHAR2,
877: x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type )
878: IS
879: l_api_version CONSTANT NUMBER := 1.0;
880: l_api_name CONSTANT VARCHAR2(50) := 'Get_DescFlex_AllPrompts';
881: l_prompt_type VARCHAR2(20);

Line 883: -- Standard call to check for call compatibility

879: l_api_version CONSTANT NUMBER := 1.0;
880: l_api_name CONSTANT VARCHAR2(50) := 'Get_DescFlex_AllPrompts';
881: l_prompt_type VARCHAR2(20);
882: BEGIN
883: -- Standard call to check for call compatibility
884: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
885: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:

Line 901: edr_standard.Get_Desc_Flex_All_Prompts (

897: l_prompt_type := 'LEFT';
898: ELSE l_prompt_type := p_prompt_type;
899: END IF;
900:
901: edr_standard.Get_Desc_Flex_All_Prompts (
902: P_APPLICATION_ID => p_application_id,
903: P_DESC_FLEX_DEF_NAME => p_descFlex_defName,
904: P_DESC_FLEX_CONTEXT => p_descFlex_context,
905: P_PROMPT_TYPE => l_prompt_type,

Line 967: -- Standard call to get message count, and if count is 1, get message info

963: P_COLUMN28_PROMPT => x_colnPrompts_rec.P_COLUMN28_PROMPT,
964: P_COLUMN29_PROMPT => x_colnPrompts_rec.P_COLUMN29_PROMPT,
965: P_COLUMN30_PROMPT => x_colnPrompts_rec.P_COLUMN30_PROMPT );
966:
967: -- Standard call to get message count, and if count is 1, get message info
968: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN

Line 995: -- Versions : 1.0 17-Jul-03 created from edr_standard.Get_Meaning

991: -- Parameters
992: -- IN : p_lookup_type VARCHAR2 event name, eg oracle.apps.gmi.item.create
993: -- p_lookup_code VARCHAR2 event key, eg ItemNo3125
994: -- OUT : x_psig_status VARCHAR2 event psig status
995: -- Versions : 1.0 17-Jul-03 created from edr_standard.Get_Meaning
996: -- ---------------------------------------
997:
998: PROCEDURE Get_Lookup_Meaning (
999: p_api_version IN NUMBER,

Line 1021: edr_standard.Get_Meaning ( P_LOOKUP_TYPE => p_lookup_type,

1017: END IF;
1018:
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;
1020:
1021: edr_standard.Get_Meaning ( P_LOOKUP_TYPE => p_lookup_type,
1022: P_LOOKUP_CODE => p_lookup_code,
1023: P_MEANING => x_lkup_meaning );
1024:
1025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 1052: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Query_One

1048: -- Parameters
1049: -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
1050: -- p_event_key VARCHAR2 event key, eg ItemNo3125
1051: -- OUT : x_query_id NUMBER one query id for all events details
1052: -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Query_One
1053: -- ---------------------------------------
1054:
1055: PROCEDURE Get_QueryId_OnParams (
1056: p_api_version IN NUMBER,

Line 1069: -- Standard call to check for call compatibility

1065: IS
1066: l_api_version CONSTANT NUMBER := 1.0;
1067: l_api_name CONSTANT VARCHAR2(50) := 'Get_QueryId_OnParams';
1068: BEGIN
1069: -- Standard call to check for call compatibility
1070: IF NOT fnd_api.Compatible_API_Call ( l_api_version, p_api_version, l_api_name, G_PKG_NAME )
1071: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073:

Line 1082: edr_standard.Psig_Query_One(

1078:
1079: -- Initialize API return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082: edr_standard.Psig_Query_One(
1083: P_EVENT_NAME => p_eventNames_tbl,
1084: P_EVENT_KEY => p_eventKeys_tbl,
1085: O_QUERY_ID => x_query_id );
1086:

Line 1090: -- Standard call to get message count, and if count is 1, get message info

1086:
1087: IF FND_API.To_Boolean( p_commit ) THEN
1088: COMMIT WORK;
1089: END IF;
1090: -- Standard call to get message count, and if count is 1, get message info
1091: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN

Line 1131: -- Standard call to check for call compatibility.

1127: WHERE EVENT_NAME = p_event_name
1128: AND EVENT_KEY = p_event_key;
1129:
1130: BEGIN
1131: -- Standard call to check for call compatibility.
1132:
1133: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1134: p_api_version ,
1135: l_api_name ,

Line 1160: -- Standard call to get message count and if count is 1,

1156: FETCH GET_CUR_ERECORD_ID INTO x_erecord_id;
1157: CLOSE GET_CUR_ERECORD_ID;
1158: edr_ctx_pkg.unset_secure_attr;
1159: --Bug 3935913: End
1160: -- Standard call to get message count and if count is 1,
1161: --get message info.
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count ,
1164: p_data => x_msg_data

Line 1249: END EDR_STANDARD_PUB;

1245:
1246:
1247:
1248:
1249: END EDR_STANDARD_PUB;