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 286: -- FND_API.G_RET_STS_SUCCESS => validation success

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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