APPS.OE_VALIDATE_ATTR dependencies on FND_API

Line 20: FND_API.g_attr_tbl.DELETE;

16: IS
17: I NUMBER:=0;
18: BEGIN
19:
20: FND_API.g_attr_tbl.DELETE;
21:
22: -- START GEN attributes
23:
24: -- Generator will append new attributes before end generate comment.

Line 27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';

23:
24: -- Generator will append new attributes before end generate comment.
25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'agreement';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'created_by';

Line 29: FND_API.g_attr_tbl(I).name := 'agreement';

25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'agreement';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'created_by';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'creation_date';

Line 31: FND_API.g_attr_tbl(I).name := 'created_by';

27: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'agreement';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'created_by';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'creation_date';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'discount';

Line 33: FND_API.g_attr_tbl(I).name := 'creation_date';

29: FND_API.g_attr_tbl(I).name := 'agreement';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'created_by';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'creation_date';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'discount';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_updated_by';

Line 35: FND_API.g_attr_tbl(I).name := 'discount';

31: FND_API.g_attr_tbl(I).name := 'created_by';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'creation_date';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'discount';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_updated_by';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_date';

Line 37: FND_API.g_attr_tbl(I).name := 'last_updated_by';

33: FND_API.g_attr_tbl(I).name := 'creation_date';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'discount';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_updated_by';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_date';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'last_update_login';

Line 39: FND_API.g_attr_tbl(I).name := 'last_update_date';

35: FND_API.g_attr_tbl(I).name := 'discount';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_updated_by';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_date';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'last_update_login';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'price_list';

Line 41: FND_API.g_attr_tbl(I).name := 'last_update_login';

37: FND_API.g_attr_tbl(I).name := 'last_updated_by';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_date';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'last_update_login';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'price_list';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'pricing_contract';

Line 43: FND_API.g_attr_tbl(I).name := 'price_list';

39: FND_API.g_attr_tbl(I).name := 'last_update_date';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'last_update_login';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'price_list';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'pricing_contract';
46:
47: I := I + 1;

Line 45: FND_API.g_attr_tbl(I).name := 'pricing_contract';

41: FND_API.g_attr_tbl(I).name := 'last_update_login';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'price_list';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'pricing_contract';
46:
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'accounting_rule';
49: I := I + 1;

Line 48: FND_API.g_attr_tbl(I).name := 'accounting_rule';

44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'pricing_contract';
46:
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'accounting_rule';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'agreement_contact';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'agreement_num';

Line 50: FND_API.g_attr_tbl(I).name := 'agreement_contact';

46:
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'accounting_rule';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'agreement_contact';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'agreement_num';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'agreement_type';

Line 52: FND_API.g_attr_tbl(I).name := 'agreement_num';

48: FND_API.g_attr_tbl(I).name := 'accounting_rule';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'agreement_contact';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'agreement_num';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'agreement_type';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'customer';

Line 54: FND_API.g_attr_tbl(I).name := 'agreement_type';

50: FND_API.g_attr_tbl(I).name := 'agreement_contact';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'agreement_num';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'agreement_type';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'customer';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'end_date_active';

Line 56: FND_API.g_attr_tbl(I).name := 'customer';

52: FND_API.g_attr_tbl(I).name := 'agreement_num';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'agreement_type';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'customer';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'end_date_active';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'freight_terms';

Line 58: FND_API.g_attr_tbl(I).name := 'end_date_active';

54: FND_API.g_attr_tbl(I).name := 'agreement_type';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'customer';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'end_date_active';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'freight_terms';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'invoice_contact';

Line 60: FND_API.g_attr_tbl(I).name := 'freight_terms';

56: FND_API.g_attr_tbl(I).name := 'customer';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'end_date_active';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'freight_terms';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'invoice_contact';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';

Line 62: FND_API.g_attr_tbl(I).name := 'invoice_contact';

58: FND_API.g_attr_tbl(I).name := 'end_date_active';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'freight_terms';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'invoice_contact';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';
65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */
66: I := I + 1;

Line 64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';

60: FND_API.g_attr_tbl(I).name := 'freight_terms';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'invoice_contact';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';
65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
68: I := I + 1;

Line 65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */

61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'invoice_contact';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';
65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'name';

Line 67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';

63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'invoice_to_site_use';
65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'name';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'override_arule';

Line 69: FND_API.g_attr_tbl(I).name := 'name';

65: /* FND_API.g_attr_tbl(I).name := 'invoice_to_org'; */
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'name';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'override_arule';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'override_irule';

Line 71: FND_API.g_attr_tbl(I).name := 'override_arule';

67: FND_API.g_attr_tbl(I).name := 'invoicing_rule';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'name';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'override_arule';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'override_irule';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';

Line 73: FND_API.g_attr_tbl(I).name := 'override_irule';

69: FND_API.g_attr_tbl(I).name := 'name';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'override_arule';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'override_irule';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'revision';

Line 75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';

71: FND_API.g_attr_tbl(I).name := 'override_arule';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'override_irule';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'revision';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'revision_date';

Line 77: FND_API.g_attr_tbl(I).name := 'revision';

73: FND_API.g_attr_tbl(I).name := 'override_irule';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'revision';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'revision_date';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'revision_reason';

Line 79: FND_API.g_attr_tbl(I).name := 'revision_date';

75: FND_API.g_attr_tbl(I).name := 'purchase_order_num';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'revision';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'revision_date';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'revision_reason';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'salesrep';

Line 81: FND_API.g_attr_tbl(I).name := 'revision_reason';

77: FND_API.g_attr_tbl(I).name := 'revision';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'revision_date';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'revision_reason';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'salesrep';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'ship_method';

Line 83: FND_API.g_attr_tbl(I).name := 'salesrep';

79: FND_API.g_attr_tbl(I).name := 'revision_date';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'revision_reason';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'salesrep';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'ship_method';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'signature_date';

Line 85: FND_API.g_attr_tbl(I).name := 'ship_method';

81: FND_API.g_attr_tbl(I).name := 'revision_reason';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'salesrep';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'ship_method';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'signature_date';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'start_date_active';

Line 87: FND_API.g_attr_tbl(I).name := 'signature_date';

83: FND_API.g_attr_tbl(I).name := 'salesrep';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'ship_method';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'signature_date';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'start_date_active';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'term';

Line 89: FND_API.g_attr_tbl(I).name := 'start_date_active';

85: FND_API.g_attr_tbl(I).name := 'ship_method';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'signature_date';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'start_date_active';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'term';
92:
93: I := I + 1;

Line 91: FND_API.g_attr_tbl(I).name := 'term';

87: FND_API.g_attr_tbl(I).name := 'signature_date';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'start_date_active';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'term';
92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'comments';
95: I := I + 1;

Line 94: FND_API.g_attr_tbl(I).name := 'comments';

90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'term';
92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'comments';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'currency';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'description';

Line 96: FND_API.g_attr_tbl(I).name := 'currency';

92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'comments';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'currency';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'description';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'program_application';

Line 98: FND_API.g_attr_tbl(I).name := 'description';

94: FND_API.g_attr_tbl(I).name := 'comments';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'currency';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'description';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'program_application';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'program';

Line 100: FND_API.g_attr_tbl(I).name := 'program_application';

96: FND_API.g_attr_tbl(I).name := 'currency';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'description';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'program_application';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'program';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'program_update_date';

Line 102: FND_API.g_attr_tbl(I).name := 'program';

98: FND_API.g_attr_tbl(I).name := 'description';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'program_application';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'program';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'program_update_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'request';

Line 104: FND_API.g_attr_tbl(I).name := 'program_update_date';

100: FND_API.g_attr_tbl(I).name := 'program_application';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'program';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'program_update_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'request';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'rounding_factor';

Line 106: FND_API.g_attr_tbl(I).name := 'request';

102: FND_API.g_attr_tbl(I).name := 'program';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'program_update_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'request';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'rounding_factor';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'secondary_price_list';

Line 108: FND_API.g_attr_tbl(I).name := 'rounding_factor';

104: FND_API.g_attr_tbl(I).name := 'program_update_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'request';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'rounding_factor';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'secondary_price_list';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'terms';

Line 110: FND_API.g_attr_tbl(I).name := 'secondary_price_list';

106: FND_API.g_attr_tbl(I).name := 'request';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'rounding_factor';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'secondary_price_list';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'terms';
113:
114: I := I + 1;

Line 112: FND_API.g_attr_tbl(I).name := 'terms';

108: FND_API.g_attr_tbl(I).name := 'rounding_factor';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'secondary_price_list';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'terms';
113:
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'amount';
116: I := I + 1;

Line 115: FND_API.g_attr_tbl(I).name := 'amount';

111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'terms';
113:
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'amount';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'automatic_discount';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'discount_lines';

Line 117: FND_API.g_attr_tbl(I).name := 'automatic_discount';

113:
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'amount';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'automatic_discount';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'discount_lines';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'discount_type';

Line 119: FND_API.g_attr_tbl(I).name := 'discount_lines';

115: FND_API.g_attr_tbl(I).name := 'amount';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'automatic_discount';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'discount_lines';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'discount_type';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';

Line 121: FND_API.g_attr_tbl(I).name := 'discount_type';

117: FND_API.g_attr_tbl(I).name := 'automatic_discount';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'discount_lines';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'discount_type';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'manual_discount';

Line 123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';

119: FND_API.g_attr_tbl(I).name := 'discount_lines';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'discount_type';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'manual_discount';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'override_allowed';

Line 125: FND_API.g_attr_tbl(I).name := 'manual_discount';

121: FND_API.g_attr_tbl(I).name := 'discount_type';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'manual_discount';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'override_allowed';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'percent';

Line 127: FND_API.g_attr_tbl(I).name := 'override_allowed';

123: FND_API.g_attr_tbl(I).name := 'gsa_indicator';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'manual_discount';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'override_allowed';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'prorate';

Line 129: FND_API.g_attr_tbl(I).name := 'percent';

125: FND_API.g_attr_tbl(I).name := 'manual_discount';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'override_allowed';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'prorate';
132:
133: I := I + 1;

Line 131: FND_API.g_attr_tbl(I).name := 'prorate';

127: FND_API.g_attr_tbl(I).name := 'override_allowed';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'prorate';
132:
133: I := I + 1;
134: FND_API.g_attr_tbl(I).name := 'customer_item';
135: I := I + 1;

Line 134: FND_API.g_attr_tbl(I).name := 'customer_item';

130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'prorate';
132:
133: I := I + 1;
134: FND_API.g_attr_tbl(I).name := 'customer_item';
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'inventory_item';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'list_price';

Line 136: FND_API.g_attr_tbl(I).name := 'inventory_item';

132:
133: I := I + 1;
134: FND_API.g_attr_tbl(I).name := 'customer_item';
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'inventory_item';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'list_price';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'method';

Line 138: FND_API.g_attr_tbl(I).name := 'list_price';

134: FND_API.g_attr_tbl(I).name := 'customer_item';
135: I := I + 1;
136: FND_API.g_attr_tbl(I).name := 'inventory_item';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'list_price';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'method';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'price_list_line';

Line 140: FND_API.g_attr_tbl(I).name := 'method';

136: FND_API.g_attr_tbl(I).name := 'inventory_item';
137: I := I + 1;
138: FND_API.g_attr_tbl(I).name := 'list_price';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'method';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'price_list_line';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';

Line 142: FND_API.g_attr_tbl(I).name := 'price_list_line';

138: FND_API.g_attr_tbl(I).name := 'list_price';
139: I := I + 1;
140: FND_API.g_attr_tbl(I).name := 'method';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'price_list_line';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';
145: I := I + 1;
146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';

Line 144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';

140: FND_API.g_attr_tbl(I).name := 'method';
141: I := I + 1;
142: FND_API.g_attr_tbl(I).name := 'price_list_line';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';
145: I := I + 1;
146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';
147: I := I + 1;
148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';

Line 146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';

142: FND_API.g_attr_tbl(I).name := 'price_list_line';
143: I := I + 1;
144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';
145: I := I + 1;
146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';
147: I := I + 1;
148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';
149: I := I + 1;
150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';

Line 148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';

144: FND_API.g_attr_tbl(I).name := 'pricing_attribute1';
145: I := I + 1;
146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';
147: I := I + 1;
148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';
149: I := I + 1;
150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';
151: I := I + 1;
152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';

Line 150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';

146: FND_API.g_attr_tbl(I).name := 'pricing_attribute10';
147: I := I + 1;
148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';
149: I := I + 1;
150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';
151: I := I + 1;
152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';
153: I := I + 1;
154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';

Line 152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';

148: FND_API.g_attr_tbl(I).name := 'pricing_attribute11';
149: I := I + 1;
150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';
151: I := I + 1;
152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';
153: I := I + 1;
154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';
155: I := I + 1;
156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';

Line 154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';

150: FND_API.g_attr_tbl(I).name := 'pricing_attribute12';
151: I := I + 1;
152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';
153: I := I + 1;
154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';
155: I := I + 1;
156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';
157: I := I + 1;
158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';

Line 156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';

152: FND_API.g_attr_tbl(I).name := 'pricing_attribute13';
153: I := I + 1;
154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';
155: I := I + 1;
156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';
157: I := I + 1;
158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';
159: I := I + 1;
160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';

Line 158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';

154: FND_API.g_attr_tbl(I).name := 'pricing_attribute14';
155: I := I + 1;
156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';
157: I := I + 1;
158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';
159: I := I + 1;
160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';
161: I := I + 1;
162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';

Line 160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';

156: FND_API.g_attr_tbl(I).name := 'pricing_attribute15';
157: I := I + 1;
158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';
159: I := I + 1;
160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';
161: I := I + 1;
162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';
163: I := I + 1;
164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';

Line 162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';

158: FND_API.g_attr_tbl(I).name := 'pricing_attribute2';
159: I := I + 1;
160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';
161: I := I + 1;
162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';
163: I := I + 1;
164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';
165: I := I + 1;
166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';

Line 164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';

160: FND_API.g_attr_tbl(I).name := 'pricing_attribute3';
161: I := I + 1;
162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';
163: I := I + 1;
164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';
165: I := I + 1;
166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';
167: I := I + 1;
168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';

Line 166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';

162: FND_API.g_attr_tbl(I).name := 'pricing_attribute4';
163: I := I + 1;
164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';
165: I := I + 1;
166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';
167: I := I + 1;
168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';
169: I := I + 1;
170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';

Line 168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';

164: FND_API.g_attr_tbl(I).name := 'pricing_attribute5';
165: I := I + 1;
166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';
167: I := I + 1;
168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';
169: I := I + 1;
170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';
171: I := I + 1;
172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';

Line 170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';

166: FND_API.g_attr_tbl(I).name := 'pricing_attribute6';
167: I := I + 1;
168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';
169: I := I + 1;
170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';
171: I := I + 1;
172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';
173: I := I + 1;
174: FND_API.g_attr_tbl(I).name := 'pricing_context';

Line 172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';

168: FND_API.g_attr_tbl(I).name := 'pricing_attribute7';
169: I := I + 1;
170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';
171: I := I + 1;
172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';
173: I := I + 1;
174: FND_API.g_attr_tbl(I).name := 'pricing_context';
175: I := I + 1;
176: FND_API.g_attr_tbl(I).name := 'pricing_rule';

Line 174: FND_API.g_attr_tbl(I).name := 'pricing_context';

170: FND_API.g_attr_tbl(I).name := 'pricing_attribute8';
171: I := I + 1;
172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';
173: I := I + 1;
174: FND_API.g_attr_tbl(I).name := 'pricing_context';
175: I := I + 1;
176: FND_API.g_attr_tbl(I).name := 'pricing_rule';
177: I := I + 1;
178: FND_API.g_attr_tbl(I).name := 'reprice';

Line 176: FND_API.g_attr_tbl(I).name := 'pricing_rule';

172: FND_API.g_attr_tbl(I).name := 'pricing_attribute9';
173: I := I + 1;
174: FND_API.g_attr_tbl(I).name := 'pricing_context';
175: I := I + 1;
176: FND_API.g_attr_tbl(I).name := 'pricing_rule';
177: I := I + 1;
178: FND_API.g_attr_tbl(I).name := 'reprice';
179: I := I + 1;
180: FND_API.g_attr_tbl(I).name := 'unit';

Line 178: FND_API.g_attr_tbl(I).name := 'reprice';

174: FND_API.g_attr_tbl(I).name := 'pricing_context';
175: I := I + 1;
176: FND_API.g_attr_tbl(I).name := 'pricing_rule';
177: I := I + 1;
178: FND_API.g_attr_tbl(I).name := 'reprice';
179: I := I + 1;
180: FND_API.g_attr_tbl(I).name := 'unit';
181:
182: I := I + 1;

Line 180: FND_API.g_attr_tbl(I).name := 'unit';

176: FND_API.g_attr_tbl(I).name := 'pricing_rule';
177: I := I + 1;
178: FND_API.g_attr_tbl(I).name := 'reprice';
179: I := I + 1;
180: FND_API.g_attr_tbl(I).name := 'unit';
181:
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'customer_class';
184: I := I + 1;

Line 183: FND_API.g_attr_tbl(I).name := 'customer_class';

179: I := I + 1;
180: FND_API.g_attr_tbl(I).name := 'unit';
181:
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'customer_class';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'discount_customer';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'site_use';

Line 185: FND_API.g_attr_tbl(I).name := 'discount_customer';

181:
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'customer_class';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'discount_customer';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'site_use';
188:
189: I := I + 1;

Line 187: FND_API.g_attr_tbl(I).name := 'site_use';

183: FND_API.g_attr_tbl(I).name := 'customer_class';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'discount_customer';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'site_use';
188:
189: I := I + 1;
190: FND_API.g_attr_tbl(I).name := 'discount_line';
191: I := I + 1;

Line 190: FND_API.g_attr_tbl(I).name := 'discount_line';

186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'site_use';
188:
189: I := I + 1;
190: FND_API.g_attr_tbl(I).name := 'discount_line';
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'entity';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'entity_value';

Line 192: FND_API.g_attr_tbl(I).name := 'entity';

188:
189: I := I + 1;
190: FND_API.g_attr_tbl(I).name := 'discount_line';
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'entity';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'entity_value';
195: I := I + 1;
196: FND_API.g_attr_tbl(I).name := 'price';

Line 194: FND_API.g_attr_tbl(I).name := 'entity_value';

190: FND_API.g_attr_tbl(I).name := 'discount_line';
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'entity';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'entity_value';
195: I := I + 1;
196: FND_API.g_attr_tbl(I).name := 'price';
197:
198: I := I + 1;

Line 196: FND_API.g_attr_tbl(I).name := 'price';

192: FND_API.g_attr_tbl(I).name := 'entity';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'entity_value';
195: I := I + 1;
196: FND_API.g_attr_tbl(I).name := 'price';
197:
198: I := I + 1;
199: FND_API.g_attr_tbl(I).name := 'method_type';
200: I := I + 1;

Line 199: FND_API.g_attr_tbl(I).name := 'method_type';

195: I := I + 1;
196: FND_API.g_attr_tbl(I).name := 'price';
197:
198: I := I + 1;
199: FND_API.g_attr_tbl(I).name := 'method_type';
200: I := I + 1;
201: FND_API.g_attr_tbl(I).name := 'price_break_high';
202: I := I + 1;
203: FND_API.g_attr_tbl(I).name := 'price_break_low';

Line 201: FND_API.g_attr_tbl(I).name := 'price_break_high';

197:
198: I := I + 1;
199: FND_API.g_attr_tbl(I).name := 'method_type';
200: I := I + 1;
201: FND_API.g_attr_tbl(I).name := 'price_break_high';
202: I := I + 1;
203: FND_API.g_attr_tbl(I).name := 'price_break_low';
204:
205: -- END GEN attributes

Line 203: FND_API.g_attr_tbl(I).name := 'price_break_low';

199: FND_API.g_attr_tbl(I).name := 'method_type';
200: I := I + 1;
201: FND_API.g_attr_tbl(I).name := 'price_break_high';
202: I := I + 1;
203: FND_API.g_attr_tbl(I).name := 'price_break_low';
204:
205: -- END GEN attributes
206:
207: END Get_Attr_Tbl;

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: ELSE
253:
254: -- In case of an unexpected error raise an exception.
255:
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257:
258: END IF;
259:
260: END IF;

Line 274: p_agreement_id = FND_API.G_MISS_NUM

270: l_dummy VARCHAR2(10);
271: BEGIN
272:
273: IF p_agreement_id IS NULL OR
274: p_agreement_id = FND_API.G_MISS_NUM
275: THEN
276: RETURN TRUE;
277: END IF;
278:

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307: , 'Agreement'
308: );
309: END IF;
310:
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312:
313: END Agreement;
314:
315: FUNCTION Created_By ( p_created_by IN NUMBER )

Line 322: p_created_by = FND_API.G_MISS_NUM

318: l_dummy VARCHAR2(10);
319: BEGIN
320:
321: IF p_created_by IS NULL OR
322: p_created_by = FND_API.G_MISS_NUM
323: THEN
324: RETURN TRUE;
325: END IF;
326:

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: , 'Created_By'
356: );
357: END IF;
358:
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360:
361: END Created_By;
362:
363: FUNCTION Creation_Date ( p_creation_date IN DATE )

Line 370: p_creation_date = FND_API.G_MISS_DATE

366: l_dummy VARCHAR2(10);
367: BEGIN
368:
369: IF p_creation_date IS NULL OR
370: p_creation_date = FND_API.G_MISS_DATE
371: THEN
372: RETURN TRUE;
373: END IF;
374:

Line 407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

403: , 'Creation_Date'
404: );
405: END IF;
406:
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408:
409: END Creation_Date;
410:
411: FUNCTION Discount ( p_discount_id IN NUMBER )

Line 418: p_discount_id = FND_API.G_MISS_NUM

414: l_dummy VARCHAR2(10);
415: BEGIN
416:
417: IF p_discount_id IS NULL OR
418: p_discount_id = FND_API.G_MISS_NUM
419: THEN
420: RETURN TRUE;
421: END IF;
422:

Line 455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451: , 'Discount'
452: );
453: END IF;
454:
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456:
457: END Discount;
458:
459: FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )

Line 466: p_last_updated_by = FND_API.G_MISS_NUM

462: l_dummy VARCHAR2(10);
463: BEGIN
464:
465: IF p_last_updated_by IS NULL OR
466: p_last_updated_by = FND_API.G_MISS_NUM
467: THEN
468: RETURN TRUE;
469: END IF;
470:

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: , 'Last_Updated_By'
500: );
501: END IF;
502:
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504:
505: END Last_Updated_By;
506:
507: FUNCTION Last_Update_Date ( p_last_update_date IN DATE )

Line 514: p_last_update_date = FND_API.G_MISS_DATE

510: l_dummy VARCHAR2(10);
511: BEGIN
512:
513: IF p_last_update_date IS NULL OR
514: p_last_update_date = FND_API.G_MISS_DATE
515: THEN
516: RETURN TRUE;
517: END IF;
518:

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547: , 'Last_Update_Date'
548: );
549: END IF;
550:
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552:
553: END Last_Update_Date;
554:
555: FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )

Line 562: p_last_update_login = FND_API.G_MISS_NUM

558: l_dummy VARCHAR2(10);
559: BEGIN
560:
561: IF p_last_update_login IS NULL OR
562: p_last_update_login = FND_API.G_MISS_NUM
563: THEN
564: RETURN TRUE;
565: END IF;
566:

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

595: , 'Last_Update_Login'
596: );
597: END IF;
598:
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600:
601: END Last_Update_Login;
602:
603: FUNCTION Price_List ( p_price_list_id IN NUMBER )

Line 610: p_price_list_id = FND_API.G_MISS_NUM

606: l_dummy VARCHAR2(10);
607: BEGIN
608:
609: IF p_price_list_id IS NULL OR
610: p_price_list_id = FND_API.G_MISS_NUM
611: THEN
612: RETURN TRUE;
613: END IF;
614:

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: , 'Price_List'
644: );
645: END IF;
646:
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648:
649: END Price_List;
650:
651: FUNCTION Pricing_Contract ( p_pricing_contract_id IN NUMBER )

Line 658: p_pricing_contract_id = FND_API.G_MISS_NUM

654: l_dummy VARCHAR2(10);
655: BEGIN
656:
657: IF p_pricing_contract_id IS NULL OR
658: p_pricing_contract_id = FND_API.G_MISS_NUM
659: THEN
660: RETURN TRUE;
661: END IF;
662:

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691: , 'Pricing_Contract'
692: );
693: END IF;
694:
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696:
697: END Pricing_Contract;
698:
699:

Line 707: p_accounting_rule_id = FND_API.G_MISS_NUM

703: l_dummy VARCHAR2(10);
704: BEGIN
705:
706: IF p_accounting_rule_id IS NULL OR
707: p_accounting_rule_id = FND_API.G_MISS_NUM
708: THEN
709: RETURN TRUE;
710: END IF;
711:

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: , 'Accounting_Rule'
741: );
742: END IF;
743:
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745:
746: END Accounting_Rule;
747:
748: FUNCTION Agreement_Contact ( p_agreement_contact_id IN NUMBER )

Line 755: p_agreement_contact_id = FND_API.G_MISS_NUM

751: l_dummy VARCHAR2(10);
752: BEGIN
753:
754: IF p_agreement_contact_id IS NULL OR
755: p_agreement_contact_id = FND_API.G_MISS_NUM
756: THEN
757: RETURN TRUE;
758: END IF;
759:

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: , 'Agreement_Contact'
789: );
790: END IF;
791:
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793:
794: END Agreement_Contact;
795:
796: FUNCTION Agreement_Num ( p_agreement_num IN VARCHAR2 )

Line 803: p_agreement_num = FND_API.G_MISS_CHAR

799: l_dummy VARCHAR2(10);
800: BEGIN
801:
802: IF p_agreement_num IS NULL OR
803: p_agreement_num = FND_API.G_MISS_CHAR
804: THEN
805: RETURN TRUE;
806: END IF;
807:

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

836: , 'Agreement_Num'
837: );
838: END IF;
839:
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841:
842: END Agreement_Num;
843:
844: FUNCTION Agreement_Type ( p_agreement_type_code IN VARCHAR2 )

Line 851: p_agreement_type_code = FND_API.G_MISS_CHAR

847: l_dummy VARCHAR2(10);
848: BEGIN
849:
850: IF p_agreement_type_code IS NULL OR
851: p_agreement_type_code = FND_API.G_MISS_CHAR
852: THEN
853: RETURN TRUE;
854: END IF;
855:

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

884: , 'Agreement_Type'
885: );
886: END IF;
887:
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889:
890: END Agreement_Type;
891:
892: /* FUNCTION Customer ( p_customer_id IN NUMBER ) */

Line 900: p_customer_id = FND_API.G_MISS_NUM

896: l_dummy VARCHAR2(10);
897: BEGIN
898: /*
899: IF p_customer_id IS NULL OR
900: p_customer_id = FND_API.G_MISS_NUM
901: THEN
902: RETURN TRUE;
903: END IF;
904: */

Line 906: p_sold_to_org_id = FND_API.G_MISS_NUM

902: RETURN TRUE;
903: END IF;
904: */
905: IF p_sold_to_org_id IS NULL OR
906: p_sold_to_org_id = FND_API.G_MISS_NUM
907: THEN
908: RETURN TRUE;
909: END IF;
910:

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: , 'Customer'
940: );
941: END IF;
942:
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944:
945: END Customer;
946:
947: FUNCTION End_Date_Active ( p_end_date_active IN DATE )

Line 954: p_end_date_active = FND_API.G_MISS_DATE

950: l_dummy VARCHAR2(10);
951: BEGIN
952:
953: IF p_end_date_active IS NULL OR
954: p_end_date_active = FND_API.G_MISS_DATE
955: THEN
956: RETURN TRUE;
957: END IF;
958:

Line 991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

987: , 'End_Date_Active'
988: );
989: END IF;
990:
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992:
993: END End_Date_Active;
994:
995: FUNCTION Start_Date_End_Date ( p_start_date_active IN DATE,

Line 1003: p_end_date_active = FND_API.G_MISS_DATE)

999: l_dummy VARCHAR2(10);
1000: BEGIN
1001:
1002: IF (p_end_date_active IS NULL OR
1003: p_end_date_active = FND_API.G_MISS_DATE)
1004: OR (p_start_date_active IS NULL OR
1005: p_start_date_active = FND_API.G_MISS_DATE)
1006: THEN
1007: RETURN TRUE;

Line 1005: p_start_date_active = FND_API.G_MISS_DATE)

1001:
1002: IF (p_end_date_active IS NULL OR
1003: p_end_date_active = FND_API.G_MISS_DATE)
1004: OR (p_start_date_active IS NULL OR
1005: p_start_date_active = FND_API.G_MISS_DATE)
1006: THEN
1007: RETURN TRUE;
1008: ELSIF (p_start_date_active > p_end_date_active ) THEN
1009: FND_MESSAGE.SET_NAME('OE', 'SO_OTHER_INVALID_DATE_RANGE');

Line 1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1043: , 'Start_Date_End_Date_Active'
1044: );
1045: END IF;
1046:
1047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1048:
1049: END Start_Date_End_Date;
1050:
1051: FUNCTION Check_Date_Range ( p_line_date_active IN DATE,

Line 1060: p_line_date_active = FND_API.G_MISS_DATE)

1056: l_dummy VARCHAR2(10);
1057: BEGIN
1058:
1059: IF (p_line_date_active IS NULL OR
1060: p_line_date_active = FND_API.G_MISS_DATE)
1061: THEN
1062: RETURN TRUE;
1063: ELSIF (p_line_date_active not between
1064: nvl(p_header_start_date_active, p_line_date_active - 1 ) and

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100: , 'Check_Date_Range'
1101: );
1102: END IF;
1103:
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105:
1106: END Check_Date_Range;
1107:
1108: FUNCTION Freight_Terms ( p_freight_terms_code IN VARCHAR2 )

Line 1115: p_freight_terms_code = FND_API.G_MISS_CHAR

1111: l_dummy VARCHAR2(10);
1112: BEGIN
1113:
1114: IF p_freight_terms_code IS NULL OR
1115: p_freight_terms_code = FND_API.G_MISS_CHAR
1116: THEN
1117: RETURN TRUE;
1118: END IF;
1119:

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1148: , 'Freight_Terms'
1149: );
1150: END IF;
1151:
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153:
1154: END Freight_Terms;
1155:
1156: FUNCTION Invoice_Contact ( p_invoice_contact_id IN NUMBER )

Line 1163: p_invoice_contact_id = FND_API.G_MISS_NUM

1159: l_dummy VARCHAR2(10);
1160: BEGIN
1161:
1162: IF p_invoice_contact_id IS NULL OR
1163: p_invoice_contact_id = FND_API.G_MISS_NUM
1164: THEN
1165: RETURN TRUE;
1166: END IF;
1167:

Line 1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1196: , 'Invoice_Contact'
1197: );
1198: END IF;
1199:
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201:
1202: END Invoice_Contact;
1203:
1204: /* FUNCTION Invoice_To_Site_Use ( p_invoice_to_site_use_id IN NUMBER ) */

Line 1212: p_invoice_to_site_use_id = FND_API.G_MISS_NUM

1208: l_dummy VARCHAR2(10);
1209: BEGIN
1210: /*
1211: IF p_invoice_to_site_use_id IS NULL OR
1212: p_invoice_to_site_use_id = FND_API.G_MISS_NUM
1213: THEN
1214: RETURN TRUE;
1215: END IF;
1216: */

Line 1218: p_invoice_to_org_id = FND_API.G_MISS_NUM

1214: RETURN TRUE;
1215: END IF;
1216: */
1217: IF p_invoice_to_org_id IS NULL OR
1218: p_invoice_to_org_id = FND_API.G_MISS_NUM
1219: THEN
1220: RETURN TRUE;
1221: END IF;
1222:

Line 1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: , 'Invoice_To_Org'
1254: );
1255: END IF;
1256:
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258:
1259: END Invoice_To_Site_Use;
1260:
1261: FUNCTION Invoicing_Rule ( p_invoicing_rule_id IN NUMBER )

Line 1268: p_invoicing_rule_id = FND_API.G_MISS_NUM

1264: l_dummy VARCHAR2(10);
1265: BEGIN
1266:
1267: IF p_invoicing_rule_id IS NULL OR
1268: p_invoicing_rule_id = FND_API.G_MISS_NUM
1269: THEN
1270: RETURN TRUE;
1271: END IF;
1272:

Line 1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1301: , 'Invoicing_Rule'
1302: );
1303: END IF;
1304:
1305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1306:
1307: END Invoicing_Rule;
1308:
1309: FUNCTION Name ( p_name IN VARCHAR2 )

Line 1316: p_name = FND_API.G_MISS_CHAR

1312: l_dummy VARCHAR2(10);
1313: BEGIN
1314:
1315: IF p_name IS NULL OR
1316: p_name = FND_API.G_MISS_CHAR
1317: THEN
1318: RETURN TRUE;
1319: END IF;
1320:

Line 1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1349: , 'Name'
1350: );
1351: END IF;
1352:
1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1354:
1355: END Name;
1356:
1357: FUNCTION Override_Arule ( p_override_arule_flag IN VARCHAR2 )

Line 1364: p_override_arule_flag = FND_API.G_MISS_CHAR

1360: l_dummy VARCHAR2(10);
1361: BEGIN
1362:
1363: IF p_override_arule_flag IS NULL OR
1364: p_override_arule_flag = FND_API.G_MISS_CHAR
1365: THEN
1366: RETURN TRUE;
1367: END IF;
1368:

Line 1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1397: , 'Override_Arule'
1398: );
1399: END IF;
1400:
1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1402:
1403: END Override_Arule;
1404:
1405: FUNCTION Override_Irule ( p_override_irule_flag IN VARCHAR2 )

Line 1412: p_override_irule_flag = FND_API.G_MISS_CHAR

1408: l_dummy VARCHAR2(10);
1409: BEGIN
1410:
1411: IF p_override_irule_flag IS NULL OR
1412: p_override_irule_flag = FND_API.G_MISS_CHAR
1413: THEN
1414: RETURN TRUE;
1415: END IF;
1416:

Line 1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1445: , 'Override_Irule'
1446: );
1447: END IF;
1448:
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450:
1451: END Override_Irule;
1452:
1453: FUNCTION Purchase_Order_Num ( p_purchase_order_num IN VARCHAR2 )

Line 1460: p_purchase_order_num = FND_API.G_MISS_CHAR

1456: l_dummy VARCHAR2(10);
1457: BEGIN
1458:
1459: IF p_purchase_order_num IS NULL OR
1460: p_purchase_order_num = FND_API.G_MISS_CHAR
1461: THEN
1462: RETURN TRUE;
1463: END IF;
1464:

Line 1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1493: , 'Purchase_Order_Num'
1494: );
1495: END IF;
1496:
1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1498:
1499: END Purchase_Order_Num;
1500:
1501: FUNCTION Revision ( p_revision IN VARCHAR2 )

Line 1508: p_revision = FND_API.G_MISS_CHAR

1504: l_dummy VARCHAR2(10);
1505: BEGIN
1506:
1507: IF p_revision IS NULL OR
1508: p_revision = FND_API.G_MISS_CHAR
1509: THEN
1510: RETURN TRUE;
1511: END IF;
1512:

Line 1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1541: , 'Revision'
1542: );
1543: END IF;
1544:
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546:
1547: END Revision;
1548:
1549: FUNCTION Revision_Date ( p_revision_date IN DATE )

Line 1556: p_revision_date = FND_API.G_MISS_DATE

1552: l_dummy VARCHAR2(10);
1553: BEGIN
1554:
1555: IF p_revision_date IS NULL OR
1556: p_revision_date = FND_API.G_MISS_DATE
1557: THEN
1558: RETURN TRUE;
1559: END IF;
1560:

Line 1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1589: , 'Revision_Date'
1590: );
1591: END IF;
1592:
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594:
1595: END Revision_Date;
1596:
1597: FUNCTION Revision_Reason ( p_revision_reason_code IN VARCHAR2 )

Line 1604: p_revision_reason_code = FND_API.G_MISS_CHAR

1600: l_dummy VARCHAR2(10);
1601: BEGIN
1602:
1603: IF p_revision_reason_code IS NULL OR
1604: p_revision_reason_code = FND_API.G_MISS_CHAR
1605: THEN
1606: RETURN TRUE;
1607: END IF;
1608:

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: , 'Revision_Reason'
1638: );
1639: END IF;
1640:
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642:
1643: END Revision_Reason;
1644:
1645: FUNCTION Salesrep ( p_salesrep_id IN NUMBER )

Line 1652: p_salesrep_id = FND_API.G_MISS_NUM

1648: l_dummy VARCHAR2(10);
1649: BEGIN
1650:
1651: IF p_salesrep_id IS NULL OR
1652: p_salesrep_id = FND_API.G_MISS_NUM
1653: THEN
1654: RETURN TRUE;
1655: END IF;
1656:

Line 1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1685: , 'Salesrep'
1686: );
1687: END IF;
1688:
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690:
1691: END Salesrep;
1692:
1693: FUNCTION Ship_Method ( p_ship_method_code IN VARCHAR2 )

Line 1700: p_ship_method_code = FND_API.G_MISS_CHAR

1696: l_dummy VARCHAR2(10);
1697: BEGIN
1698:
1699: IF p_ship_method_code IS NULL OR
1700: p_ship_method_code = FND_API.G_MISS_CHAR
1701: THEN
1702: RETURN TRUE;
1703: END IF;
1704:

Line 1737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1733: , 'Ship_Method'
1734: );
1735: END IF;
1736:
1737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1738:
1739: END Ship_Method;
1740:
1741: FUNCTION Signature_Date ( p_signature_date IN DATE )

Line 1748: p_signature_date = FND_API.G_MISS_DATE

1744: l_dummy VARCHAR2(10);
1745: BEGIN
1746:
1747: IF p_signature_date IS NULL OR
1748: p_signature_date = FND_API.G_MISS_DATE
1749: THEN
1750: RETURN TRUE;
1751: END IF;
1752:

Line 1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1781: , 'Signature_Date'
1782: );
1783: END IF;
1784:
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786:
1787: END Signature_Date;
1788:
1789: FUNCTION Start_Date_Active ( p_start_date_active IN DATE )

Line 1796: p_start_date_active = FND_API.G_MISS_DATE

1792: l_dummy VARCHAR2(10);
1793: BEGIN
1794:
1795: IF p_start_date_active IS NULL OR
1796: p_start_date_active = FND_API.G_MISS_DATE
1797: THEN
1798: RETURN TRUE;
1799: END IF;
1800:

Line 1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1829: , 'Start_Date_Active'
1830: );
1831: END IF;
1832:
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834:
1835: END Start_Date_Active;
1836:
1837: FUNCTION Term ( p_term_id IN NUMBER )

Line 1844: p_term_id = FND_API.G_MISS_NUM

1840: l_dummy VARCHAR2(10);
1841: BEGIN
1842:
1843: IF p_term_id IS NULL OR
1844: p_term_id = FND_API.G_MISS_NUM
1845: THEN
1846: RETURN TRUE;
1847: END IF;
1848:

Line 1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1877: , 'Term'
1878: );
1879: END IF;
1880:
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882:
1883: END Term;
1884:
1885:

Line 1894: p_agreement_source_code = FND_API.G_MISS_CHAR

1890: l_dummy VARCHAR2(10);
1891: BEGIN
1892:
1893: IF p_agreement_source_code IS NULL OR
1894: p_agreement_source_code = FND_API.G_MISS_CHAR
1895: THEN
1896: RETURN TRUE;
1897: END IF;
1898:

Line 1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1927: , 'Agreement_Source'
1928: );
1929: END IF;
1930:
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932:
1933: END Agreement_Source;
1934:
1935: FUNCTION Orig_System_Agr ( p_orig_system_agr_id IN NUMBER )

Line 1942: p_orig_system_agr_id = FND_API.G_MISS_NUM

1938: l_dummy VARCHAR2(10);
1939: BEGIN
1940:
1941: IF p_orig_system_agr_id IS NULL OR
1942: p_orig_system_agr_id = FND_API.G_MISS_NUM
1943: THEN
1944: RETURN TRUE;
1945: END IF;
1946:

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1975: , 'Orig_System_Agr'
1976: );
1977: END IF;
1978:
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980:
1981: END Orig_System_Agr;
1982: --End code added by rchellam for OKC
1983:

Line 1992: p_invoice_to_customer_id = FND_API.G_MISS_NUM

1988: l_dummy VARCHAR2(10);
1989: BEGIN
1990:
1991: IF p_invoice_to_customer_id IS NULL OR
1992: p_invoice_to_customer_id = FND_API.G_MISS_NUM
1993: THEN
1994: RETURN TRUE;
1995: END IF;
1996:

Line 2029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2025: , 'Invoice_To_Customer_Id'
2026: );
2027: END IF;
2028:
2029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2030:
2031: END Invoice_To_Customer_Id;
2032:
2033: FUNCTION Comments ( p_comments IN VARCHAR2 )

Line 2040: p_comments = FND_API.G_MISS_CHAR

2036: l_dummy VARCHAR2(10);
2037: BEGIN
2038:
2039: IF p_comments IS NULL OR
2040: p_comments = FND_API.G_MISS_CHAR
2041: THEN
2042: RETURN TRUE;
2043: END IF;
2044:

Line 2077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2073: , 'Comments'
2074: );
2075: END IF;
2076:
2077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2078:
2079: END Comments;
2080:
2081: FUNCTION Currency ( p_currency_code IN VARCHAR2 )

Line 2088: p_currency_code = FND_API.G_MISS_CHAR

2084: l_dummy VARCHAR2(10);
2085: BEGIN
2086:
2087: IF p_currency_code IS NULL OR
2088: p_currency_code = FND_API.G_MISS_CHAR
2089: THEN
2090: RETURN TRUE;
2091: END IF;
2092:

Line 2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2121: , 'Currency'
2122: );
2123: END IF;
2124:
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126:
2127: END Currency;
2128:
2129: FUNCTION Currency ( p_currency_code IN VARCHAR2,

Line 2141: p_currency_code = FND_API.G_MISS_CHAR

2137: l_dummy VARCHAR2(10);
2138: BEGIN
2139:
2140: IF p_currency_code IS NULL OR
2141: p_currency_code = FND_API.G_MISS_CHAR
2142: THEN
2143: RETURN TRUE;
2144: END IF;
2145:

Line 2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2186: , 'Currency'
2187: );
2188: END IF;
2189:
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191:
2192: END Currency;
2193:
2194: FUNCTION Description ( p_description IN VARCHAR2 )

Line 2201: p_description = FND_API.G_MISS_CHAR

2197: l_dummy VARCHAR2(10);
2198: BEGIN
2199:
2200: IF p_description IS NULL OR
2201: p_description = FND_API.G_MISS_CHAR
2202: THEN
2203: RETURN TRUE;
2204: END IF;
2205:

Line 2238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2234: , 'Description'
2235: );
2236: END IF;
2237:
2238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2239:
2240: END Description;
2241:
2242: FUNCTION Program_Application ( p_program_application_id IN NUMBER )

Line 2249: p_program_application_id = FND_API.G_MISS_NUM

2245: l_dummy VARCHAR2(10);
2246: BEGIN
2247:
2248: IF p_program_application_id IS NULL OR
2249: p_program_application_id = FND_API.G_MISS_NUM
2250: THEN
2251: RETURN TRUE;
2252: END IF;
2253:

Line 2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2282: , 'Program_Application'
2283: );
2284: END IF;
2285:
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2287:
2288: END Program_Application;
2289:
2290: FUNCTION Program ( p_program_id IN NUMBER )

Line 2297: p_program_id = FND_API.G_MISS_NUM

2293: l_dummy VARCHAR2(10);
2294: BEGIN
2295:
2296: IF p_program_id IS NULL OR
2297: p_program_id = FND_API.G_MISS_NUM
2298: THEN
2299: RETURN TRUE;
2300: END IF;
2301:

Line 2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2330: , 'Program'
2331: );
2332: END IF;
2333:
2334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2335:
2336: END Program;
2337:
2338: FUNCTION Program_Update_Date ( p_program_update_date IN DATE )

Line 2345: p_program_update_date = FND_API.G_MISS_DATE

2341: l_dummy VARCHAR2(10);
2342: BEGIN
2343:
2344: IF p_program_update_date IS NULL OR
2345: p_program_update_date = FND_API.G_MISS_DATE
2346: THEN
2347: RETURN TRUE;
2348: END IF;
2349:

Line 2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2378: , 'Program_Update_Date'
2379: );
2380: END IF;
2381:
2382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2383:
2384: END Program_Update_Date;
2385:
2386: FUNCTION Request ( p_request_id IN NUMBER )

Line 2393: p_request_id = FND_API.G_MISS_NUM

2389: l_dummy VARCHAR2(10);
2390: BEGIN
2391:
2392: IF p_request_id IS NULL OR
2393: p_request_id = FND_API.G_MISS_NUM
2394: THEN
2395: RETURN TRUE;
2396: END IF;
2397:

Line 2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2426: , 'Request'
2427: );
2428: END IF;
2429:
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431:
2432: END Request;
2433:
2434: FUNCTION Rounding_Factor ( p_rounding_factor IN NUMBER )

Line 2441: p_rounding_factor = FND_API.G_MISS_NUM

2437: l_dummy VARCHAR2(10);
2438: BEGIN
2439:
2440: IF p_rounding_factor IS NULL OR
2441: p_rounding_factor = FND_API.G_MISS_NUM
2442: THEN
2443: RETURN TRUE;
2444: END IF;
2445:

Line 2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2474: , 'Rounding_Factor'
2475: );
2476: END IF;
2477:
2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2479:
2480: END Rounding_Factor;
2481:
2482: FUNCTION Secondary_Price_List ( p_secondary_price_list_id IN NUMBER )

Line 2489: p_secondary_price_list_id = FND_API.G_MISS_NUM

2485: l_dummy VARCHAR2(10);
2486: BEGIN
2487:
2488: IF p_secondary_price_list_id IS NULL OR
2489: p_secondary_price_list_id = FND_API.G_MISS_NUM
2490: THEN
2491: RETURN TRUE;
2492: END IF;
2493:

Line 2526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2522: , 'Secondary_Price_List'
2523: );
2524: END IF;
2525:
2526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2527:
2528: END Secondary_Price_List;
2529:
2530: FUNCTION Terms ( p_terms_id IN NUMBER )

Line 2537: p_terms_id = FND_API.G_MISS_NUM

2533: l_dummy VARCHAR2(10);
2534: BEGIN
2535:
2536: IF p_terms_id IS NULL OR
2537: p_terms_id = FND_API.G_MISS_NUM
2538: THEN
2539: RETURN TRUE;
2540: END IF;
2541:

Line 2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2570: , 'Terms'
2571: );
2572: END IF;
2573:
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575:
2576: END Terms;
2577:
2578:

Line 2586: p_amount = FND_API.G_MISS_NUM

2582: l_dummy VARCHAR2(10);
2583: BEGIN
2584:
2585: IF p_amount IS NULL OR
2586: p_amount = FND_API.G_MISS_NUM
2587: THEN
2588: RETURN TRUE;
2589: END IF;
2590:

Line 2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2619: , 'Amount'
2620: );
2621: END IF;
2622:
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624:
2625: END Amount;
2626:
2627: FUNCTION Automatic_Discount ( p_automatic_discount_flag IN VARCHAR2 )

Line 2634: p_automatic_discount_flag = FND_API.G_MISS_CHAR

2630: l_dummy VARCHAR2(10);
2631: BEGIN
2632:
2633: IF p_automatic_discount_flag IS NULL OR
2634: p_automatic_discount_flag = FND_API.G_MISS_CHAR
2635: THEN
2636: RETURN TRUE;
2637: END IF;
2638:

Line 2671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2667: , 'Automatic_Discount'
2668: );
2669: END IF;
2670:
2671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2672:
2673: END Automatic_Discount;
2674:
2675: FUNCTION Discount_Lines ( p_discount_lines_flag IN VARCHAR2 )

Line 2682: p_discount_lines_flag = FND_API.G_MISS_CHAR

2678: l_dummy VARCHAR2(10);
2679: BEGIN
2680:
2681: IF p_discount_lines_flag IS NULL OR
2682: p_discount_lines_flag = FND_API.G_MISS_CHAR
2683: THEN
2684: RETURN TRUE;
2685: END IF;
2686:

Line 2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2715: , 'Discount_Lines'
2716: );
2717: END IF;
2718:
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720:
2721: END Discount_Lines;
2722:
2723: FUNCTION Discount_Type ( p_discount_type_code IN VARCHAR2 )

Line 2730: p_discount_type_code = FND_API.G_MISS_CHAR

2726: l_dummy VARCHAR2(10);
2727: BEGIN
2728:
2729: IF p_discount_type_code IS NULL OR
2730: p_discount_type_code = FND_API.G_MISS_CHAR
2731: THEN
2732: RETURN TRUE;
2733: END IF;
2734:

Line 2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2763: , 'Discount_Type'
2764: );
2765: END IF;
2766:
2767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2768:
2769: END Discount_Type;
2770:
2771: FUNCTION Gsa_Indicator ( p_gsa_indicator IN VARCHAR2 )

Line 2778: p_gsa_indicator = FND_API.G_MISS_CHAR

2774: l_dummy VARCHAR2(10);
2775: BEGIN
2776:
2777: IF p_gsa_indicator IS NULL OR
2778: p_gsa_indicator = FND_API.G_MISS_CHAR
2779: THEN
2780: RETURN TRUE;
2781: END IF;
2782:

Line 2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2811: , 'Gsa_Indicator'
2812: );
2813: END IF;
2814:
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2816:
2817: END Gsa_Indicator;
2818:
2819: FUNCTION Manual_Discount ( p_manual_discount_flag IN VARCHAR2 )

Line 2826: p_manual_discount_flag = FND_API.G_MISS_CHAR

2822: l_dummy VARCHAR2(10);
2823: BEGIN
2824:
2825: IF p_manual_discount_flag IS NULL OR
2826: p_manual_discount_flag = FND_API.G_MISS_CHAR
2827: THEN
2828: RETURN TRUE;
2829: END IF;
2830:

Line 2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2859: , 'Manual_Discount'
2860: );
2861: END IF;
2862:
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2864:
2865: END Manual_Discount;
2866:
2867: FUNCTION Override_Allowed ( p_override_allowed_flag IN VARCHAR2 )

Line 2874: p_override_allowed_flag = FND_API.G_MISS_CHAR

2870: l_dummy VARCHAR2(10);
2871: BEGIN
2872:
2873: IF p_override_allowed_flag IS NULL OR
2874: p_override_allowed_flag = FND_API.G_MISS_CHAR
2875: THEN
2876: RETURN TRUE;
2877: END IF;
2878:

Line 2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2907: , 'Override_Allowed'
2908: );
2909: END IF;
2910:
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912:
2913: END Override_Allowed;
2914:
2915: FUNCTION Percent ( p_percent IN NUMBER )

Line 2922: p_percent = FND_API.G_MISS_NUM

2918: l_dummy VARCHAR2(10);
2919: BEGIN
2920:
2921: IF p_percent IS NULL OR
2922: p_percent = FND_API.G_MISS_NUM
2923: THEN
2924: RETURN TRUE;
2925: END IF;
2926:

Line 2959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2955: , 'Percent'
2956: );
2957: END IF;
2958:
2959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2960:
2961: END Percent;
2962:
2963: FUNCTION Prorate ( p_prorate_flag IN VARCHAR2 )

Line 2970: p_prorate_flag = FND_API.G_MISS_CHAR

2966: l_dummy VARCHAR2(10);
2967: BEGIN
2968:
2969: IF p_prorate_flag IS NULL OR
2970: p_prorate_flag = FND_API.G_MISS_CHAR
2971: THEN
2972: RETURN TRUE;
2973: END IF;
2974:

Line 3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3003: , 'Prorate'
3004: );
3005: END IF;
3006:
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008:
3009: END Prorate;
3010:
3011:

Line 3019: p_customer_item_id = FND_API.G_MISS_NUM

3015: l_dummy VARCHAR2(10);
3016: BEGIN
3017:
3018: IF p_customer_item_id IS NULL OR
3019: p_customer_item_id = FND_API.G_MISS_NUM
3020: THEN
3021: RETURN TRUE;
3022: END IF;
3023:

Line 3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3052: , 'Customer_Item'
3053: );
3054: END IF;
3055:
3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3057:
3058: END Customer_Item;
3059:
3060: FUNCTION Inventory_Item ( p_inventory_item_id IN NUMBER,

Line 3061: p_organization_id IN NUMBER DEFAULT FND_API.G_MISS_NUM)

3057:
3058: END Customer_Item;
3059:
3060: FUNCTION Inventory_Item ( p_inventory_item_id IN NUMBER,
3061: p_organization_id IN NUMBER DEFAULT FND_API.G_MISS_NUM)
3062: RETURN BOOLEAN
3063: IS
3064: l_dummy VARCHAR2(10);
3065: x_unit_code VARCHAR2(3) := '';

Line 3071: p_inventory_item_id = FND_API.G_MISS_NUM)

3067:
3068: BEGIN
3069:
3070: IF (p_inventory_item_id IS NULL OR
3071: p_inventory_item_id = FND_API.G_MISS_NUM)
3072: OR (p_organization_id is NULL OR
3073: p_organization_id = FND_API.G_MISS_NUM)
3074: THEN
3075: RETURN TRUE;

Line 3073: p_organization_id = FND_API.G_MISS_NUM)

3069:
3070: IF (p_inventory_item_id IS NULL OR
3071: p_inventory_item_id = FND_API.G_MISS_NUM)
3072: OR (p_organization_id is NULL OR
3073: p_organization_id = FND_API.G_MISS_NUM)
3074: THEN
3075: RETURN TRUE;
3076: ELSE
3077: OE_Validate_Attr.getservitemflag(p_inventory_item_id,

Line 3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3113: , 'Inventory_Item'
3114: );
3115: END IF;
3116:
3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3118:
3119: END Inventory_Item;
3120:
3121: FUNCTION List_Price ( p_list_price IN NUMBER )

Line 3128: p_list_price = FND_API.G_MISS_NUM

3124: l_dummy VARCHAR2(10);
3125: BEGIN
3126:
3127: IF p_list_price IS NULL OR
3128: p_list_price = FND_API.G_MISS_NUM
3129: THEN
3130: RETURN TRUE;
3131: END IF;
3132:

Line 3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3161: , 'List_Price'
3162: );
3163: END IF;
3164:
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166:
3167: END List_Price;
3168:
3169: FUNCTION Method ( p_method_code IN VARCHAR2 )

Line 3176: p_method_code = FND_API.G_MISS_CHAR

3172: l_dummy VARCHAR2(10);
3173: BEGIN
3174:
3175: IF p_method_code IS NULL OR
3176: p_method_code = FND_API.G_MISS_CHAR
3177: THEN
3178: RETURN TRUE;
3179: END IF;
3180:

Line 3213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3209: , 'Method'
3210: );
3211: END IF;
3212:
3213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3214:
3215: END Method;
3216:
3217: FUNCTION Price_List_Line ( p_price_list_line_id IN NUMBER )

Line 3224: p_price_list_line_id = FND_API.G_MISS_NUM

3220: l_dummy VARCHAR2(10);
3221: BEGIN
3222:
3223: IF p_price_list_line_id IS NULL OR
3224: p_price_list_line_id = FND_API.G_MISS_NUM
3225: THEN
3226: RETURN TRUE;
3227: END IF;
3228:

Line 3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3257: , 'Price_List_Line'
3258: );
3259: END IF;
3260:
3261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3262:
3263: END Price_List_Line;
3264:
3265: FUNCTION Pricing_Attribute1 ( p_pricing_attribute1 IN VARCHAR2 )

Line 3272: p_pricing_attribute1 = FND_API.G_MISS_CHAR

3268: l_dummy VARCHAR2(10);
3269: BEGIN
3270:
3271: IF p_pricing_attribute1 IS NULL OR
3272: p_pricing_attribute1 = FND_API.G_MISS_CHAR
3273: THEN
3274: RETURN TRUE;
3275: END IF;
3276:

Line 3309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3305: , 'Pricing_Attribute1'
3306: );
3307: END IF;
3308:
3309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3310:
3311: END Pricing_Attribute1;
3312:
3313: FUNCTION Pricing_Attribute10 ( p_pricing_attribute10 IN VARCHAR2 )

Line 3320: p_pricing_attribute10 = FND_API.G_MISS_CHAR

3316: l_dummy VARCHAR2(10);
3317: BEGIN
3318:
3319: IF p_pricing_attribute10 IS NULL OR
3320: p_pricing_attribute10 = FND_API.G_MISS_CHAR
3321: THEN
3322: RETURN TRUE;
3323: END IF;
3324:

Line 3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3353: , 'Pricing_Attribute10'
3354: );
3355: END IF;
3356:
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358:
3359: END Pricing_Attribute10;
3360:
3361: FUNCTION Pricing_Attribute11 ( p_pricing_attribute11 IN VARCHAR2 )

Line 3368: p_pricing_attribute11 = FND_API.G_MISS_CHAR

3364: l_dummy VARCHAR2(10);
3365: BEGIN
3366:
3367: IF p_pricing_attribute11 IS NULL OR
3368: p_pricing_attribute11 = FND_API.G_MISS_CHAR
3369: THEN
3370: RETURN TRUE;
3371: END IF;
3372:

Line 3405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3401: , 'Pricing_Attribute11'
3402: );
3403: END IF;
3404:
3405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3406:
3407: END Pricing_Attribute11;
3408:
3409: FUNCTION Pricing_Attribute12 ( p_pricing_attribute12 IN VARCHAR2 )

Line 3416: p_pricing_attribute12 = FND_API.G_MISS_CHAR

3412: l_dummy VARCHAR2(10);
3413: BEGIN
3414:
3415: IF p_pricing_attribute12 IS NULL OR
3416: p_pricing_attribute12 = FND_API.G_MISS_CHAR
3417: THEN
3418: RETURN TRUE;
3419: END IF;
3420:

Line 3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3449: , 'Pricing_Attribute12'
3450: );
3451: END IF;
3452:
3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454:
3455: END Pricing_Attribute12;
3456:
3457: FUNCTION Pricing_Attribute13 ( p_pricing_attribute13 IN VARCHAR2 )

Line 3464: p_pricing_attribute13 = FND_API.G_MISS_CHAR

3460: l_dummy VARCHAR2(10);
3461: BEGIN
3462:
3463: IF p_pricing_attribute13 IS NULL OR
3464: p_pricing_attribute13 = FND_API.G_MISS_CHAR
3465: THEN
3466: RETURN TRUE;
3467: END IF;
3468:

Line 3501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3497: , 'Pricing_Attribute13'
3498: );
3499: END IF;
3500:
3501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3502:
3503: END Pricing_Attribute13;
3504:
3505: FUNCTION Pricing_Attribute14 ( p_pricing_attribute14 IN VARCHAR2 )

Line 3512: p_pricing_attribute14 = FND_API.G_MISS_CHAR

3508: l_dummy VARCHAR2(10);
3509: BEGIN
3510:
3511: IF p_pricing_attribute14 IS NULL OR
3512: p_pricing_attribute14 = FND_API.G_MISS_CHAR
3513: THEN
3514: RETURN TRUE;
3515: END IF;
3516:

Line 3549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3545: , 'Pricing_Attribute14'
3546: );
3547: END IF;
3548:
3549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3550:
3551: END Pricing_Attribute14;
3552:
3553: FUNCTION Pricing_Attribute15 ( p_pricing_attribute15 IN VARCHAR2 )

Line 3560: p_pricing_attribute15 = FND_API.G_MISS_CHAR

3556: l_dummy VARCHAR2(10);
3557: BEGIN
3558:
3559: IF p_pricing_attribute15 IS NULL OR
3560: p_pricing_attribute15 = FND_API.G_MISS_CHAR
3561: THEN
3562: RETURN TRUE;
3563: END IF;
3564:

Line 3597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3593: , 'Pricing_Attribute15'
3594: );
3595: END IF;
3596:
3597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3598:
3599: END Pricing_Attribute15;
3600:
3601: FUNCTION Pricing_Attribute2 ( p_pricing_attribute2 IN VARCHAR2 )

Line 3608: p_pricing_attribute2 = FND_API.G_MISS_CHAR

3604: l_dummy VARCHAR2(10);
3605: BEGIN
3606:
3607: IF p_pricing_attribute2 IS NULL OR
3608: p_pricing_attribute2 = FND_API.G_MISS_CHAR
3609: THEN
3610: RETURN TRUE;
3611: END IF;
3612:

Line 3645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3641: , 'Pricing_Attribute2'
3642: );
3643: END IF;
3644:
3645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3646:
3647: END Pricing_Attribute2;
3648:
3649: FUNCTION Pricing_Attribute3 ( p_pricing_attribute3 IN VARCHAR2 )

Line 3656: p_pricing_attribute3 = FND_API.G_MISS_CHAR

3652: l_dummy VARCHAR2(10);
3653: BEGIN
3654:
3655: IF p_pricing_attribute3 IS NULL OR
3656: p_pricing_attribute3 = FND_API.G_MISS_CHAR
3657: THEN
3658: RETURN TRUE;
3659: END IF;
3660:

Line 3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3689: , 'Pricing_Attribute3'
3690: );
3691: END IF;
3692:
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694:
3695: END Pricing_Attribute3;
3696:
3697: FUNCTION Pricing_Attribute4 ( p_pricing_attribute4 IN VARCHAR2 )

Line 3704: p_pricing_attribute4 = FND_API.G_MISS_CHAR

3700: l_dummy VARCHAR2(10);
3701: BEGIN
3702:
3703: IF p_pricing_attribute4 IS NULL OR
3704: p_pricing_attribute4 = FND_API.G_MISS_CHAR
3705: THEN
3706: RETURN TRUE;
3707: END IF;
3708:

Line 3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3737: , 'Pricing_Attribute4'
3738: );
3739: END IF;
3740:
3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3742:
3743: END Pricing_Attribute4;
3744:
3745: FUNCTION Pricing_Attribute5 ( p_pricing_attribute5 IN VARCHAR2 )

Line 3752: p_pricing_attribute5 = FND_API.G_MISS_CHAR

3748: l_dummy VARCHAR2(10);
3749: BEGIN
3750:
3751: IF p_pricing_attribute5 IS NULL OR
3752: p_pricing_attribute5 = FND_API.G_MISS_CHAR
3753: THEN
3754: RETURN TRUE;
3755: END IF;
3756:

Line 3789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3785: , 'Pricing_Attribute5'
3786: );
3787: END IF;
3788:
3789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3790:
3791: END Pricing_Attribute5;
3792:
3793: FUNCTION Pricing_Attribute6 ( p_pricing_attribute6 IN VARCHAR2 )

Line 3800: p_pricing_attribute6 = FND_API.G_MISS_CHAR

3796: l_dummy VARCHAR2(10);
3797: BEGIN
3798:
3799: IF p_pricing_attribute6 IS NULL OR
3800: p_pricing_attribute6 = FND_API.G_MISS_CHAR
3801: THEN
3802: RETURN TRUE;
3803: END IF;
3804:

Line 3837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3833: , 'Pricing_Attribute6'
3834: );
3835: END IF;
3836:
3837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3838:
3839: END Pricing_Attribute6;
3840:
3841: FUNCTION Pricing_Attribute7 ( p_pricing_attribute7 IN VARCHAR2 )

Line 3848: p_pricing_attribute7 = FND_API.G_MISS_CHAR

3844: l_dummy VARCHAR2(10);
3845: BEGIN
3846:
3847: IF p_pricing_attribute7 IS NULL OR
3848: p_pricing_attribute7 = FND_API.G_MISS_CHAR
3849: THEN
3850: RETURN TRUE;
3851: END IF;
3852:

Line 3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3881: , 'Pricing_Attribute7'
3882: );
3883: END IF;
3884:
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886:
3887: END Pricing_Attribute7;
3888:
3889: FUNCTION Pricing_Attribute8 ( p_pricing_attribute8 IN VARCHAR2 )

Line 3896: p_pricing_attribute8 = FND_API.G_MISS_CHAR

3892: l_dummy VARCHAR2(10);
3893: BEGIN
3894:
3895: IF p_pricing_attribute8 IS NULL OR
3896: p_pricing_attribute8 = FND_API.G_MISS_CHAR
3897: THEN
3898: RETURN TRUE;
3899: END IF;
3900:

Line 3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3929: , 'Pricing_Attribute8'
3930: );
3931: END IF;
3932:
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934:
3935: END Pricing_Attribute8;
3936:
3937: FUNCTION Pricing_Attribute9 ( p_pricing_attribute9 IN VARCHAR2 )

Line 3944: p_pricing_attribute9 = FND_API.G_MISS_CHAR

3940: l_dummy VARCHAR2(10);
3941: BEGIN
3942:
3943: IF p_pricing_attribute9 IS NULL OR
3944: p_pricing_attribute9 = FND_API.G_MISS_CHAR
3945: THEN
3946: RETURN TRUE;
3947: END IF;
3948:

Line 3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3977: , 'Pricing_Attribute9'
3978: );
3979: END IF;
3980:
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982:
3983: END Pricing_Attribute9;
3984:
3985: FUNCTION Pricing_Context ( p_pricing_context IN VARCHAR2 )

Line 3992: p_pricing_context = FND_API.G_MISS_CHAR

3988: l_dummy VARCHAR2(10);
3989: BEGIN
3990:
3991: IF p_pricing_context IS NULL OR
3992: p_pricing_context = FND_API.G_MISS_CHAR
3993: THEN
3994: RETURN TRUE;
3995: END IF;
3996:

Line 4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4025: , 'Pricing_Context'
4026: );
4027: END IF;
4028:
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030:
4031: END Pricing_Context;
4032:
4033: FUNCTION Pricing_Rule ( p_pricing_rule_id IN NUMBER )

Line 4040: p_pricing_rule_id = FND_API.G_MISS_NUM

4036: l_dummy VARCHAR2(10);
4037: BEGIN
4038:
4039: IF p_pricing_rule_id IS NULL OR
4040: p_pricing_rule_id = FND_API.G_MISS_NUM
4041: THEN
4042: RETURN TRUE;
4043: END IF;
4044:

Line 4077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4073: , 'Pricing_Rule'
4074: );
4075: END IF;
4076:
4077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4078:
4079: END Pricing_Rule;
4080:
4081: FUNCTION Reprice ( p_reprice_flag IN VARCHAR2 )

Line 4088: p_reprice_flag = FND_API.G_MISS_CHAR

4084: l_dummy VARCHAR2(10);
4085: BEGIN
4086:
4087: IF p_reprice_flag IS NULL OR
4088: p_reprice_flag = FND_API.G_MISS_CHAR
4089: THEN
4090: RETURN TRUE;
4091: END IF;
4092:

Line 4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4121: , 'Reprice'
4122: );
4123: END IF;
4124:
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126:
4127: END Reprice;
4128:
4129: FUNCTION Unit ( p_unit_code IN VARCHAR2 )

Line 4136: p_unit_code = FND_API.G_MISS_CHAR

4132: l_dummy VARCHAR2(10);
4133: BEGIN
4134:
4135: IF p_unit_code IS NULL OR
4136: p_unit_code = FND_API.G_MISS_CHAR
4137: THEN
4138: RETURN TRUE;
4139: END IF;
4140:

Line 4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4169: , 'Unit'
4170: );
4171: END IF;
4172:
4173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4174:
4175: END Unit;
4176:
4177:

Line 4185: p_customer_class_code = FND_API.G_MISS_CHAR

4181: l_dummy VARCHAR2(10);
4182: BEGIN
4183:
4184: IF p_customer_class_code IS NULL OR
4185: p_customer_class_code = FND_API.G_MISS_CHAR
4186: THEN
4187: RETURN TRUE;
4188: END IF;
4189:

Line 4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4218: , 'Customer_Class'
4219: );
4220: END IF;
4221:
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223:
4224: END Customer_Class;
4225:
4226: FUNCTION Discount_Customer ( p_discount_customer_id IN NUMBER )

Line 4233: p_discount_customer_id = FND_API.G_MISS_NUM

4229: l_dummy VARCHAR2(10);
4230: BEGIN
4231:
4232: IF p_discount_customer_id IS NULL OR
4233: p_discount_customer_id = FND_API.G_MISS_NUM
4234: THEN
4235: RETURN TRUE;
4236: END IF;
4237:

Line 4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4266: , 'Discount_Customer'
4267: );
4268: END IF;
4269:
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271:
4272: END Discount_Customer;
4273:
4274: /* FUNCTION Site_Use ( p_site_use_id IN NUMBER ) */

Line 4282: p_site_use_id = FND_API.G_MISS_NUM

4278: l_dummy VARCHAR2(10);
4279: BEGIN
4280: /*
4281: IF p_site_use_id IS NULL OR
4282: p_site_use_id = FND_API.G_MISS_NUM
4283: THEN
4284: RETURN TRUE;
4285: END IF;
4286: */

Line 4288: p_site_org_id = FND_API.G_MISS_NUM

4284: RETURN TRUE;
4285: END IF;
4286: */
4287: IF p_site_org_id IS NULL OR
4288: p_site_org_id = FND_API.G_MISS_NUM
4289: THEN
4290: RETURN TRUE;
4291: END IF;
4292:

Line 4325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4321: , 'Site_Use'
4322: );
4323: END IF;
4324:
4325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4326:
4327: END Site_Use;
4328:
4329:

Line 4337: p_discount_line_id = FND_API.G_MISS_NUM

4333: l_dummy VARCHAR2(10);
4334: BEGIN
4335:
4336: IF p_discount_line_id IS NULL OR
4337: p_discount_line_id = FND_API.G_MISS_NUM
4338: THEN
4339: RETURN TRUE;
4340: END IF;
4341:

Line 4374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4370: , 'Discount_Line'
4371: );
4372: END IF;
4373:
4374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4375:
4376: END Discount_Line;
4377:
4378: FUNCTION Entity ( p_entity_id IN NUMBER )

Line 4385: p_entity_id = FND_API.G_MISS_NUM

4381: l_dummy VARCHAR2(10);
4382: BEGIN
4383:
4384: IF p_entity_id IS NULL OR
4385: p_entity_id = FND_API.G_MISS_NUM
4386: THEN
4387: RETURN TRUE;
4388: END IF;
4389:

Line 4422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4418: , 'Entity'
4419: );
4420: END IF;
4421:
4422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4423:
4424: END Entity;
4425:
4426: FUNCTION Entity_Value ( p_entity_value IN VARCHAR2 )

Line 4433: p_entity_value = FND_API.G_MISS_CHAR

4429: l_dummy VARCHAR2(10);
4430: BEGIN
4431:
4432: IF p_entity_value IS NULL OR
4433: p_entity_value = FND_API.G_MISS_CHAR
4434: THEN
4435: RETURN TRUE;
4436: END IF;
4437:

Line 4470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4466: , 'Entity_Value'
4467: );
4468: END IF;
4469:
4470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4471:
4472: END Entity_Value;
4473:
4474: FUNCTION Price ( p_price IN NUMBER )

Line 4481: p_price = FND_API.G_MISS_NUM

4477: l_dummy VARCHAR2(10);
4478: BEGIN
4479:
4480: IF p_price IS NULL OR
4481: p_price = FND_API.G_MISS_NUM
4482: THEN
4483: RETURN TRUE;
4484: END IF;
4485:

Line 4518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4514: , 'Price'
4515: );
4516: END IF;
4517:
4518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4519:
4520: END Price;
4521:
4522:

Line 4530: p_method_type_code = FND_API.G_MISS_CHAR

4526: l_dummy VARCHAR2(10);
4527: BEGIN
4528:
4529: IF p_method_type_code IS NULL OR
4530: p_method_type_code = FND_API.G_MISS_CHAR
4531: THEN
4532: RETURN TRUE;
4533: END IF;
4534:

Line 4567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4563: , 'Method_Type'
4564: );
4565: END IF;
4566:
4567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4568:
4569: END Method_Type;
4570:
4571: FUNCTION Price_Break_High ( p_price_break_high IN NUMBER )

Line 4578: p_price_break_high = FND_API.G_MISS_NUM

4574: l_dummy VARCHAR2(10);
4575: BEGIN
4576:
4577: IF p_price_break_high IS NULL OR
4578: p_price_break_high = FND_API.G_MISS_NUM
4579: THEN
4580: RETURN TRUE;
4581: END IF;
4582:

Line 4615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4611: , 'Price_Break_High'
4612: );
4613: END IF;
4614:
4615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4616:
4617: END Price_Break_High;
4618:
4619: FUNCTION Price_Break_Low ( p_price_break_low IN NUMBER )

Line 4626: p_price_break_low = FND_API.G_MISS_NUM

4622: l_dummy VARCHAR2(10);
4623: BEGIN
4624:
4625: IF p_price_break_low IS NULL OR
4626: p_price_break_low = FND_API.G_MISS_NUM
4627: THEN
4628: RETURN TRUE;
4629: END IF;
4630:

Line 4663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4659: , 'Price_Break_Low'
4660: );
4661: END IF;
4662:
4663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4664:
4665: END Price_Break_Low;
4666:
4667: PROCEDURE getservitemflag(p_inventory_item_id IN NUMBER,

Line 4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4771: , 'PRIMARY_EXISTS'
4772: );
4773: END IF;
4774:
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776:
4777: END PRIMARY_EXISTS;
4778:
4779: FUNCTION PRIMARY(p_primary IN VARCHAR2) RETURN BOOLEAN

Line 4785: p_primary = FND_API.G_MISS_CHAR

4781: l_dummy VARCHAR2(10);
4782: BEGIN
4783:
4784: IF p_primary IS NULL OR
4785: p_primary = FND_API.G_MISS_CHAR
4786: THEN
4787: RETURN TRUE;
4788: END IF;
4789:

Line 4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4818: , 'PRIMARY'
4819: );
4820: END IF;
4821:
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823:
4824: END PRIMARY;
4825:
4826: FUNCTION List_Line_Type ( p_list_line_type_code in VARCHAR2 )

Line 4833: p_list_line_type_code = FND_API.G_MISS_CHAR

4829: l_dummy VARCHAR2(10);
4830: BEGIN
4831:
4832: IF p_list_line_type_code IS NULL OR
4833: p_list_line_type_code = FND_API.G_MISS_CHAR
4834: THEN
4835: RETURN TRUE;
4836: END IF;
4837:

Line 4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4866: , 'List Line Type'
4867: );
4868: END IF;
4869:
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871:
4872: END List_Line_Type;
4873:
4874: -- END GEN validate