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

Line 80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),

76: media_id,
77: list_used_by,
78: list_used_by_id
79: ) VALUES (
80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),
81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),

77: list_used_by,
78: list_used_by_id
79: ) VALUES (
80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),
81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

78: list_used_by_id
79: ) VALUES (
80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),
81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

79: ) VALUES (
80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),
81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

80: DECODE( px_list_cont_restrictions_id, FND_API.g_miss_num, NULL, px_list_cont_restrictions_id),
81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),

Line 85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

81: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),

Line 86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

82: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),

Line 87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

83: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),
91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));

Line 88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),

84: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),
91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));
92: END Insert_Row;

Line 89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),

85: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),
91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));
92: END Insert_Row;
93:

Line 90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),

86: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),
91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));
92: END Insert_Row;
93:
94:

Line 91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));

87: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
88: DECODE( p_do_not_contact_flag, FND_API.g_miss_char, NULL, p_do_not_contact_flag),
89: DECODE( p_media_id, FND_API.g_miss_num, NULL, p_media_id),
90: DECODE( p_list_used_by, FND_API.g_miss_char, NULL, p_list_used_by),
91: DECODE( p_list_used_by_id, FND_API.g_miss_num, NULL, p_list_used_by_id));
92: END Insert_Row;
93:
94:
95: ----------------------------------------------------------

Line 130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),

126: BEGIN
127:
128: Update AMS_LIST_CONT_RESTRICTIONS
129: SET
130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

127:
128: Update AMS_LIST_CONT_RESTRICTIONS
129: SET
130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

128: Update AMS_LIST_CONT_RESTRICTIONS
129: SET
130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

129: SET
130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),

Line 135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),

Line 136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),

Line 137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),
141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)

Line 138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),

134: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),
141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)
142: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID

Line 139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),

135: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),
141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)
142: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
143: AND object_version_number = p_object_version_number;

Line 140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),

136: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),
141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)
142: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
143: AND object_version_number = p_object_version_number;
144:

Line 141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)

137: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
138: do_not_contact_flag = DECODE( p_do_not_contact_flag, FND_API.g_miss_char, do_not_contact_flag, p_do_not_contact_flag),
139: media_id = DECODE( p_media_id, FND_API.g_miss_num, media_id, p_media_id),
140: list_used_by = DECODE( p_list_used_by, FND_API.g_miss_char, list_used_by, p_list_used_by),
141: list_used_by_id = DECODE( p_list_used_by_id, FND_API.g_miss_num, list_used_by_id, p_list_used_by_id)
142: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
143: AND object_version_number = p_object_version_number;
144:
145: IF (SQL%NOTFOUND) THEN

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
143: AND object_version_number = p_object_version_number;
144:
145: IF (SQL%NOTFOUND) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END Update_Row;
149:
150:

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170: BEGIN
171: DELETE FROM AMS_LIST_CONT_RESTRICTIONS
172: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID;
173: If (SQL%NOTFOUND) then
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: End If;
176: END Delete_Row ;
177:
178:

Line 334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

330: p_list_used_by => p_list_used_by ,
331: p_list_used_by_id => p_list_used_by_id );
332:
333:
334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337: else
338: close c_chk_col_exists;

Line 335: RAISE FND_API.G_EXC_ERROR;

331: p_list_used_by_id => p_list_used_by_id );
332:
333:
334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337: else
338: close c_chk_col_exists;
339: