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.CS_SERVICEREQUEST_UTIL dependencies on FND_API

Line 53: p_parent_type_id IN NUMBER := FND_API.G_MISS_NUM,

49: p_api_name IN VARCHAR2,
50: p_parameter_name IN VARCHAR2,
51: p_type_name IN VARCHAR2,
52: p_subtype IN VARCHAR2,
53: p_parent_type_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_type_id OUT NOCOPY NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2
56: ) ;
57:

Line 151: -- Default = FND_API.G_MISS_CHAR

147: -- p_parameter_name_n IN VARCHAR2 Required
148: -- Name of the second value-based parameter in the calling
149: -- procedure (e.g. 'p_customer_name').
150: -- p_customer_number IN VARCHAR2(30) Optional
151: -- Default = FND_API.G_MISS_CHAR
152: -- Value of the customer number to be converted.
153: -- p_customer_name IN VARCHAR2(50) Optional
154: -- Default = FND_API.G_MISS_CHAR
155: -- Value of the customer name to be converted.

Line 154: -- Default = FND_API.G_MISS_CHAR

150: -- p_customer_number IN VARCHAR2(30) Optional
151: -- Default = FND_API.G_MISS_CHAR
152: -- Value of the customer number to be converted.
153: -- p_customer_name IN VARCHAR2(50) Optional
154: -- Default = FND_API.G_MISS_CHAR
155: -- Value of the customer name to be converted.
156: -- OUT : p_customer_id OUT NUMBER
157: -- x_return_status OUT VARCHAR2(1)
158: --

Line 167: p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR,

163: PROCEDURE Convert_Customer_To_ID
164: ( p_api_name IN VARCHAR2,
165: p_parameter_name_nb IN VARCHAR2,
166: p_parameter_name_n IN VARCHAR2,
167: p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_customer_id OUT NOCOPY NUMBER,
170: x_return_status OUT NOCOPY VARCHAR2
171: );

Line 168: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

164: ( p_api_name IN VARCHAR2,
165: p_parameter_name_nb IN VARCHAR2,
166: p_parameter_name_n IN VARCHAR2,
167: p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
169: p_customer_id OUT NOCOPY NUMBER,
170: x_return_status OUT NOCOPY VARCHAR2
171: );
172:

Line 188: -- Default = FND_API.G_MISS_CHAR

184: -- p_parameter_name_n IN VARCHAR2 Required
185: -- Name of the second value-based parameter in the calling
186: -- procedure (e.g. 'p_employee_name').
187: -- p_employee_number IN VARCHAR2(30) Optional
188: -- Default = FND_API.G_MISS_CHAR
189: -- Value of the employee number to be converted.
190: -- p_employee_name IN VARCHAR2(50) Optional
191: -- Default = FND_API.G_MISS_CHAR
192: -- Value of the employee name to be converted.

Line 191: -- Default = FND_API.G_MISS_CHAR

187: -- p_employee_number IN VARCHAR2(30) Optional
188: -- Default = FND_API.G_MISS_CHAR
189: -- Value of the employee number to be converted.
190: -- p_employee_name IN VARCHAR2(50) Optional
191: -- Default = FND_API.G_MISS_CHAR
192: -- Value of the employee name to be converted.
193: -- OUT : p_employee_id OUT NUMBER
194: -- x_return_status OUT VARCHAR2(1)
195: --

Line 204: p_employee_number IN VARCHAR2 := FND_API.G_MISS_CHAR,

200:
201: PROCEDURE Convert_Employee_To_ID
202: ( p_api_name IN VARCHAR2,
203: p_parameter_name_nb IN VARCHAR2,
204: p_employee_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_employee_id OUT NOCOPY NUMBER,
206: x_return_status OUT NOCOPY VARCHAR2
207: );
208:

Line 285: -- FND_API.G_RET_STS_SUCCESS => validation success

281: -- Name of the value based parameter in the calling procedure
282: -- p_user_id IN NUMBER Required Length = 15
283: -- p_login_id IN NUMBER Required Length = 15
284: -- OUT: x_return_status OUT VARCHAR2 Required Length = 1
285: -- FND_API.G_RET_STS_SUCCESS => validation success
286: -- FND_API.G_RET_STS_ERROR => validation failure
287: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
288: -- End of comments
289: -- --------------------------------------------------------------------------------

Line 286: -- FND_API.G_RET_STS_ERROR => validation failure

282: -- p_user_id IN NUMBER Required Length = 15
283: -- p_login_id IN NUMBER Required Length = 15
284: -- OUT: x_return_status OUT VARCHAR2 Required Length = 1
285: -- FND_API.G_RET_STS_SUCCESS => validation success
286: -- FND_API.G_RET_STS_ERROR => validation failure
287: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
288: -- End of comments
289: -- --------------------------------------------------------------------------------
290: PROCEDURE Validate_Who_Info (

Line 287: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

283: -- p_login_id IN NUMBER Required Length = 15
284: -- OUT: x_return_status OUT VARCHAR2 Required Length = 1
285: -- FND_API.G_RET_STS_SUCCESS => validation success
286: -- FND_API.G_RET_STS_ERROR => validation failure
287: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
288: -- End of comments
289: -- --------------------------------------------------------------------------------
290: PROCEDURE Validate_Who_Info (
291: p_api_name IN VARCHAR2,

Line 317: -- FND_API.G_RET_STS_SUCCESS => type is valid

313: -- Service request subtype (e.g. 'INC').
314: -- p_status_id IN NUMBER Required
315: -- Identifier of the service request status.
316: -- OUT : x_return_status OUT VARCHAR2(1)
317: -- FND_API.G_RET_STS_SUCCESS => type is valid
318: -- FND_API.G_RET_STS_ERROR => type is invalid
319: --
320: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
321: -- handled by the calling procedure.

Line 318: -- FND_API.G_RET_STS_ERROR => type is invalid

314: -- p_status_id IN NUMBER Required
315: -- Identifier of the service request status.
316: -- OUT : x_return_status OUT VARCHAR2(1)
317: -- FND_API.G_RET_STS_SUCCESS => type is valid
318: -- FND_API.G_RET_STS_ERROR => type is invalid
319: --
320: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
321: -- handled by the calling procedure.
322: -- End of Comments

Line 370: -- FND_API.G_RET_STS_SUCCESS => status is valid

366: -- p_type_id IN NUMBER Required
367: -- Identifier of the service request type related to the status.
368: -- OUT : p_close_flag OUT VARCHAR2(1)
369: -- x_return_status OUT VARCHAR2(1)
370: -- FND_API.G_RET_STS_SUCCESS => status is valid
371: -- FND_API.G_RET_STS_ERROR => status is invalid
372: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
373: -- handled by the calling procedure.
374: -- End of Comments

Line 371: -- FND_API.G_RET_STS_ERROR => status is invalid

367: -- Identifier of the service request type related to the status.
368: -- OUT : p_close_flag OUT VARCHAR2(1)
369: -- x_return_status OUT VARCHAR2(1)
370: -- FND_API.G_RET_STS_SUCCESS => status is valid
371: -- FND_API.G_RET_STS_ERROR => status is invalid
372: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
373: -- handled by the calling procedure.
374: -- End of Comments
375: -- -----------------------------------------------------------------------

Line 440: -- FND_API.G_RET_STS_SUCCESS => validation success

436: -- p_parameter_name IN VARCHAR2 Required
437: -- Name of the value based parameter in the calling procedure
438: -- p_urgency_id IN NUMBER Required Length = 15
439: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
440: -- FND_API.G_RET_STS_SUCCESS => validation success
441: -- FND_API.G_RET_STS_ERROR => validation failure
442: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
443: -- End of comments
444: -- --------------------------------------------------------------------------------

Line 441: -- FND_API.G_RET_STS_ERROR => validation failure

437: -- Name of the value based parameter in the calling procedure
438: -- p_urgency_id IN NUMBER Required Length = 15
439: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
440: -- FND_API.G_RET_STS_SUCCESS => validation success
441: -- FND_API.G_RET_STS_ERROR => validation failure
442: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
443: -- End of comments
444: -- --------------------------------------------------------------------------------
445: PROCEDURE Validate_Urgency (

Line 442: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

438: -- p_urgency_id IN NUMBER Required Length = 15
439: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
440: -- FND_API.G_RET_STS_SUCCESS => validation success
441: -- FND_API.G_RET_STS_ERROR => validation failure
442: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
443: -- End of comments
444: -- --------------------------------------------------------------------------------
445: PROCEDURE Validate_Urgency (
446: p_api_name IN VARCHAR2,

Line 467: -- FND_API.G_RET_STS_SUCCESS => date is valid

463: -- Closed date.
464: -- p_request_date IN DATE Required
465: -- Service request date.
466: -- OUT : x_return_status OUT VARCHAR2(1)
467: -- FND_API.G_RET_STS_SUCCESS => date is valid
468: -- FND_API.G_RET_STS_ERROR => date is invalid
469: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
470: -- handled by the calling procedure.
471: -- End of Comments

Line 468: -- FND_API.G_RET_STS_ERROR => date is invalid

464: -- p_request_date IN DATE Required
465: -- Service request date.
466: -- OUT : x_return_status OUT VARCHAR2(1)
467: -- FND_API.G_RET_STS_SUCCESS => date is valid
468: -- FND_API.G_RET_STS_ERROR => date is invalid
469: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
470: -- handled by the calling procedure.
471: -- End of Comments
472: -- -----------------------------------------------------------------------

Line 548: -- FND_API.G_RET_STS_SUCCESS => contact is valid

544: -- p_org_id IN NUMBER Optional
545: -- Organization ID.
546: -- OUT : p_employee_name OUT VARCHAR2(240)
547: -- x_return_status OUT VARCHAR2(1)
548: -- FND_API.G_RET_STS_SUCCESS => contact is valid
549: -- FND_API.G_RET_STS_ERROR => contact is invalid
550: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
551: -- handled by the calling procedure.
552: -- End of Comments

Line 549: -- FND_API.G_RET_STS_ERROR => contact is invalid

545: -- Organization ID.
546: -- OUT : p_employee_name OUT VARCHAR2(240)
547: -- x_return_status OUT VARCHAR2(1)
548: -- FND_API.G_RET_STS_SUCCESS => contact is valid
549: -- FND_API.G_RET_STS_ERROR => contact is invalid
550: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
551: -- handled by the calling procedure.
552: -- End of Comments
553: -- -----------------------------------------------------------------------

Line 580: -- FND_API.G_RET_STS_SUCCESS => validation success

576: -- p_caller_type IN VARCHAR2
577: -- Party_type information passed by the SR invocation program.
578: -- Addition for Bug 3666089 Ends.
579: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
580: -- FND_API.G_RET_STS_SUCCESS => validation success
581: -- FND_API.G_RET_STS_ERROR => validation failure
582: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
583: -- End of comments
584: -- --------------------------------------------------------------------------------

Line 581: -- FND_API.G_RET_STS_ERROR => validation failure

577: -- Party_type information passed by the SR invocation program.
578: -- Addition for Bug 3666089 Ends.
579: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
580: -- FND_API.G_RET_STS_SUCCESS => validation success
581: -- FND_API.G_RET_STS_ERROR => validation failure
582: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
583: -- End of comments
584: -- --------------------------------------------------------------------------------
585: PROCEDURE Validate_Customer (

Line 582: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

578: -- Addition for Bug 3666089 Ends.
579: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
580: -- FND_API.G_RET_STS_SUCCESS => validation success
581: -- FND_API.G_RET_STS_ERROR => validation failure
582: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
583: -- End of comments
584: -- --------------------------------------------------------------------------------
585: PROCEDURE Validate_Customer (
586: p_api_name IN VARCHAR2,

Line 610: -- FND_API.G_RET_STS_SUCCESS => contact is valid

606: -- ID of the service request customer.
607: -- p_org_id IN NUMBER Optional
608: -- Value of the organization ID.
609: -- OUT : x_return_status OUT VARCHAR2(1)
610: -- FND_API.G_RET_STS_SUCCESS => contact is valid
611: -- FND_API.G_RET_STS_ERROR => contact is invalid
612: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
613: -- handled by the calling procedure.
614: -- Added one more in parameter as p_customer_type, to get the header

Line 611: -- FND_API.G_RET_STS_ERROR => contact is invalid

607: -- p_org_id IN NUMBER Optional
608: -- Value of the organization ID.
609: -- OUT : x_return_status OUT VARCHAR2(1)
610: -- FND_API.G_RET_STS_SUCCESS => contact is valid
611: -- FND_API.G_RET_STS_ERROR => contact is invalid
612: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
613: -- handled by the calling procedure.
614: -- Added one more in parameter as p_customer_type, to get the header
615: -- customer_type by shijain.

Line 662: -- FND_API.G_RET_STS_SUCCESS => CP is valid

658: -- Value of the organization ID.
659: -- OUT : p_customer_id OUT NUMBER
660: -- p_inventory_item_id OUT NUMBER
661: -- x_return_status OUT VARCHAR2(1)
662: -- FND_API.G_RET_STS_SUCCESS => CP is valid
663: -- FND_API.G_RET_STS_ERROR => CP is invalid
664: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
665: -- handled by the calling procedure.
666: -- End of Comments

Line 663: -- FND_API.G_RET_STS_ERROR => CP is invalid

659: -- OUT : p_customer_id OUT NUMBER
660: -- p_inventory_item_id OUT NUMBER
661: -- x_return_status OUT VARCHAR2(1)
662: -- FND_API.G_RET_STS_SUCCESS => CP is valid
663: -- FND_API.G_RET_STS_ERROR => CP is invalid
664: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
665: -- handled by the calling procedure.
666: -- End of Comments
667: -- -----------------------------------------------------------------------

Line 694: -- FND_API.G_RET_STS_SUCCESS => validation success

690: -- p_inventory_item_id IN NUMBER Required Length = 15
691: -- p_inventory_org_id IN NUMBER Required Length = 15
692: -- p_maint_organization_id IN NUMBER Required Length = 15
693: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
694: -- FND_API.G_RET_STS_SUCCESS => validation success
695: -- FND_API.G_RET_STS_ERROR => validation failure
696: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
697: -- Modification History
698: -- Date Name Description

Line 695: -- FND_API.G_RET_STS_ERROR => validation failure

691: -- p_inventory_org_id IN NUMBER Required Length = 15
692: -- p_maint_organization_id IN NUMBER Required Length = 15
693: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
694: -- FND_API.G_RET_STS_SUCCESS => validation success
695: -- FND_API.G_RET_STS_ERROR => validation failure
696: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
697: -- Modification History
698: -- Date Name Description
699: -- -------- -------- -----------------------------------------------------------

Line 696: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

692: -- p_maint_organization_id IN NUMBER Required Length = 15
693: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
694: -- FND_API.G_RET_STS_SUCCESS => validation success
695: -- FND_API.G_RET_STS_ERROR => validation failure
696: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
697: -- Modification History
698: -- Date Name Description
699: -- -------- -------- -----------------------------------------------------------
700: -- 06/07/05 smisra Added p_maint_organization_id parameter

Line 730: -- FND_API.G_RET_STS_SUCCESS => validation success

726: -- p_parameter_name IN VARCHAR2 Required
727: -- Name of the value based parameter in the calling procedure
728: -- p_cust_pref_lang_id IN NUMBER Required
729: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
730: -- FND_API.G_RET_STS_SUCCESS => validation success
731: -- FND_API.G_RET_STS_ERROR => validation failure
732: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
733: -- End of comments
734:

Line 731: -- FND_API.G_RET_STS_ERROR => validation failure

727: -- Name of the value based parameter in the calling procedure
728: -- p_cust_pref_lang_id IN NUMBER Required
729: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
730: -- FND_API.G_RET_STS_SUCCESS => validation success
731: -- FND_API.G_RET_STS_ERROR => validation failure
732: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
733: -- End of comments
734:
735: PROCEDURE Validate_Cust_Pref_Lang_Code (

Line 732: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

728: -- p_cust_pref_lang_id IN NUMBER Required
729: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
730: -- FND_API.G_RET_STS_SUCCESS => validation success
731: -- FND_API.G_RET_STS_ERROR => validation failure
732: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
733: -- End of comments
734:
735: PROCEDURE Validate_Cust_Pref_Lang_Code (
736: p_api_name IN VARCHAR2,

Line 807: -- FND_API.G_RET_STS_SUCCESS => date is valid

803: -- Expected resolution date.
804: -- p_request_date IN DATE Required
805: -- Service request date.
806: -- OUT : x_return_status OUT VARCHAR2(1)
807: -- FND_API.G_RET_STS_SUCCESS => date is valid
808: -- FND_API.G_RET_STS_ERROR => date is invalid
809: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
810: -- handled by the calling procedure.
811: -- End of Comments

Line 808: -- FND_API.G_RET_STS_ERROR => date is invalid

804: -- p_request_date IN DATE Required
805: -- Service request date.
806: -- OUT : x_return_status OUT VARCHAR2(1)
807: -- FND_API.G_RET_STS_SUCCESS => date is valid
808: -- FND_API.G_RET_STS_ERROR => date is invalid
809: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
810: -- handled by the calling procedure.
811: -- End of Comments
812: -- -----------------------------------------------------------------------

Line 841: -- FND_API.G_RET_STS_SUCCESS => date is valid

837: -- Expected resolution date.
838: -- p_request_date IN DATE Required
839: -- Service request date.
840: -- OUT : x_return_status OUT VARCHAR2(1)
841: -- FND_API.G_RET_STS_SUCCESS => date is valid
842: -- FND_API.G_RET_STS_ERROR => date is invalid
843: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
844: -- handled by the calling procedure.
845: -- End of Comments

Line 842: -- FND_API.G_RET_STS_ERROR => date is invalid

838: -- p_request_date IN DATE Required
839: -- Service request date.
840: -- OUT : x_return_status OUT VARCHAR2(1)
841: -- FND_API.G_RET_STS_SUCCESS => date is valid
842: -- FND_API.G_RET_STS_ERROR => date is invalid
843: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
844: -- handled by the calling procedure.
845: -- End of Comments
846: -- -----------------------------------------------------------------------

Line 870: -- FND_API.G_RET_STS_SUCCESS => site is valid

866: -- p_customer_id IN NUMBER Required
867: -- ID of the service request customer.
868: -- OUT : p_install_customer_id OUT NUMBER
869: -- x_return_status OUT VARCHAR2(1)
870: -- FND_API.G_RET_STS_SUCCESS => site is valid
871: -- FND_API.G_RET_STS_ERROR => site is invalid
872: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
873: -- handled by the calling procedure.
874: -- End of Comments

Line 871: -- FND_API.G_RET_STS_ERROR => site is invalid

867: -- ID of the service request customer.
868: -- OUT : p_install_customer_id OUT NUMBER
869: -- x_return_status OUT VARCHAR2(1)
870: -- FND_API.G_RET_STS_SUCCESS => site is valid
871: -- FND_API.G_RET_STS_ERROR => site is invalid
872: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
873: -- handled by the calling procedure.
874: -- End of Comments
875: -- -----------------------------------------------------------------------

Line 897: -- FND_API.G_RET_STS_SUCCESS => code is valid

893: -- (e.g. 'p_resolution_code').
894: -- p_resolution_code IN VARCHAR2(30) Required
895: -- Resolution code.
896: -- OUT : x_return_status OUT VARCHAR2(1)
897: -- FND_API.G_RET_STS_SUCCESS => code is valid
898: -- FND_API.G_RET_STS_ERROR => code is invalid
899: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
900: -- handled by the calling procedure.
901: -- End of Comments

Line 898: -- FND_API.G_RET_STS_ERROR => code is invalid

894: -- p_resolution_code IN VARCHAR2(30) Required
895: -- Resolution code.
896: -- OUT : x_return_status OUT VARCHAR2(1)
897: -- FND_API.G_RET_STS_SUCCESS => code is valid
898: -- FND_API.G_RET_STS_ERROR => code is invalid
899: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
900: -- handled by the calling procedure.
901: -- End of Comments
902: -- -----------------------------------------------------------------------

Line 924: -- FND_API.G_RET_STS_SUCCESS => validation success

920: -- Name of the value based parameter in the calling procedure
921: -- p_act_resolution_date IN DATE Required
922: -- p_request_date IN DATE Required
923: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
924: -- FND_API.G_RET_STS_SUCCESS => validation success
925: -- FND_API.G_RET_STS_ERROR => validation failure
926: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
927: -- End of comments
928: -- --------------------------------------------------------------------------------

Line 925: -- FND_API.G_RET_STS_ERROR => validation failure

921: -- p_act_resolution_date IN DATE Required
922: -- p_request_date IN DATE Required
923: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
924: -- FND_API.G_RET_STS_SUCCESS => validation success
925: -- FND_API.G_RET_STS_ERROR => validation failure
926: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
927: -- End of comments
928: -- --------------------------------------------------------------------------------
929: PROCEDURE Validate_Act_Resolution_Date (

Line 926: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred

922: -- p_request_date IN DATE Required
923: -- OUT:x_return_status OUT VARCHAR2 Required Length = 1
924: -- FND_API.G_RET_STS_SUCCESS => validation success
925: -- FND_API.G_RET_STS_ERROR => validation failure
926: -- FND_API.G_RET_STS_UNEXP_ERROR => unexpected error occurred
927: -- End of comments
928: -- --------------------------------------------------------------------------------
929: PROCEDURE Validate_Act_Resolution_Date (
930: p_api_name IN VARCHAR2,

Line 1357: -- FND_API.G_RET_STS_SUCCESS => source_program_code is valid

1353: -- (e.g. 'p_source_program_code').
1354: -- p_source_program_code IN VARCHAR2(30) Required
1355: -- Service request source program code
1356: -- OUT : x_return_status OUT VARCHAR2(1)
1357: -- FND_API.G_RET_STS_SUCCESS => source_program_code is valid
1358: -- FND_API.G_RET_STS_ERROR => source_program_code is invalid
1359: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1360: -- handled by the calling procedure.
1361: -- End of Comments

Line 1358: -- FND_API.G_RET_STS_ERROR => source_program_code is invalid

1354: -- p_source_program_code IN VARCHAR2(30) Required
1355: -- Service request source program code
1356: -- OUT : x_return_status OUT VARCHAR2(1)
1357: -- FND_API.G_RET_STS_SUCCESS => source_program_code is valid
1358: -- FND_API.G_RET_STS_ERROR => source_program_code is invalid
1359: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1360: -- handled by the calling procedure.
1361: -- End of Comments
1362: -- -----------------------------------------------------------------------

Line 1434: -- FND_API.G_RET_STS_SUCCESS => Bill_to_Account is valid

1430: -- p_parameter_name IN VARCHAR2 Required Name of parameter in the calling procedure (e.g. 'p_bill_to_account').
1431: -- p_bill_to_account_id IN NUMBER Required Unique bill to account identifier
1432: -- p_bill_to_customer_id IN NUMBER Unique Bill to customer ientifier
1433: -- OUT :x_return_status OUT VARCHAR2(1)
1434: -- FND_API.G_RET_STS_SUCCESS => Bill_to_Account is valid
1435: -- FND_API.G_RET_STS_ERROR => Bill_to_Account is invalid
1436: -- -----------------------------------------------------------------------
1437:
1438: PROCEDURE Validate_Bill_To_Ship_To_Acct

Line 1435: -- FND_API.G_RET_STS_ERROR => Bill_to_Account is invalid

1431: -- p_bill_to_account_id IN NUMBER Required Unique bill to account identifier
1432: -- p_bill_to_customer_id IN NUMBER Unique Bill to customer ientifier
1433: -- OUT :x_return_status OUT VARCHAR2(1)
1434: -- FND_API.G_RET_STS_SUCCESS => Bill_to_Account is valid
1435: -- FND_API.G_RET_STS_ERROR => Bill_to_Account is invalid
1436: -- -----------------------------------------------------------------------
1437:
1438: PROCEDURE Validate_Bill_To_Ship_To_Acct
1439: ( p_api_name IN VARCHAR2,

Line 1460: -- FND_API.G_RET_STS_SUCCESS => INC_DIST_QUAL_UOM is valid

1456: -- (e.g. 'P_INC_DIST_QUAL_UOM').
1457: -- P_INC_DIST_QUAL_UOM IN VARCHAR2(30)
1458: -- Service request incident distance qualifier UOM
1459: -- OUT : x_return_status OUT VARCHAR2(1)
1460: -- FND_API.G_RET_STS_SUCCESS => INC_DIST_QUAL_UOM is valid
1461: -- FND_API.G_RET_STS_ERROR => INC_DIST_QUAL_UOM is invalid
1462: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1463: -- handled by the calling procedure.
1464: -- End of Comments

Line 1461: -- FND_API.G_RET_STS_ERROR => INC_DIST_QUAL_UOM is invalid

1457: -- P_INC_DIST_QUAL_UOM IN VARCHAR2(30)
1458: -- Service request incident distance qualifier UOM
1459: -- OUT : x_return_status OUT VARCHAR2(1)
1460: -- FND_API.G_RET_STS_SUCCESS => INC_DIST_QUAL_UOM is valid
1461: -- FND_API.G_RET_STS_ERROR => INC_DIST_QUAL_UOM is invalid
1462: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1463: -- handled by the calling procedure.
1464: -- End of Comments
1465: -- -----------------------------------------------------------------------

Line 1487: -- FND_API.G_RET_STS_SUCCESS => INC_DIRECTION_QUAL is valid

1483: -- (e.g. 'p_INC_DIRECTION_QUAL').
1484: -- p_INC_DIRECTION_QUAL IN VARCHAR2(30)
1485: -- Service request incident direction qualifier
1486: -- OUT : x_return_status OUT VARCHAR2(1)
1487: -- FND_API.G_RET_STS_SUCCESS => INC_DIRECTION_QUAL is valid
1488: -- FND_API.G_RET_STS_ERROR => INC_DIRECTION_QUAL is invalid
1489: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1490: -- handled by the calling procedure.
1491: -- End of Comments

Line 1488: -- FND_API.G_RET_STS_ERROR => INC_DIRECTION_QUAL is invalid

1484: -- p_INC_DIRECTION_QUAL IN VARCHAR2(30)
1485: -- Service request incident direction qualifier
1486: -- OUT : x_return_status OUT VARCHAR2(1)
1487: -- FND_API.G_RET_STS_SUCCESS => INC_DIRECTION_QUAL is valid
1488: -- FND_API.G_RET_STS_ERROR => INC_DIRECTION_QUAL is invalid
1489: -- Notes : Unknown exceptions (i.e. unexpected errors) should be
1490: -- handled by the calling procedure.
1491: -- End of Comments
1492: -- -----------------------------------------------------------------------