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

Line 82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),

78: last_updated_by,
79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),
83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),

Line 83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),

79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),
83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),

Line 84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

80: last_update_login
81: ) VALUES (
82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),
83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),

Line 85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

81: ) VALUES (
82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),
83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),

Line 86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),

82: DECODE( px_party_notification_id, FND_API.G_MISS_NUM, NULL, px_party_notification_id),
83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),

83: DECODE( p_notification_id, FND_API.G_MISS_NUM, NULL, p_notification_id),
84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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

84: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),

85: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

86: DECODE( p_recipient_user_id, FND_API.G_MISS_NUM, NULL, p_recipient_user_id),
87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

87: DECODE( p_notif_for_entity_id, FND_API.G_MISS_NUM, NULL, p_notif_for_entity_id),
88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:

Line 92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

88: DECODE( p_arc_notif_for_entity_code, FND_API.g_miss_char, NULL, p_arc_notif_for_entity_code),
89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;

Line 93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

89: DECODE( p_notif_type_code, FND_API.g_miss_char, NULL, p_notif_type_code),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:

Line 94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
91: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
92: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
93: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
94: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
95:
96: END Insert_Row;
97:
98:

Line 130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),

126: IS
127: BEGIN
128: Update pv_ge_party_notifications
129: SET
130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),
131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),

Line 131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),

127: BEGIN
128: Update pv_ge_party_notifications
129: SET
130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),
131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),

Line 133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

129: SET
130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),
131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),

Line 134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),

130: party_notification_id = DECODE( p_party_notification_id, null, party_notification_id, FND_API.G_MISS_NUM, null, p_party_notification_id),
131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),

131: notification_id = DECODE( p_notification_id, null, notification_id, FND_API.G_MISS_NUM, null, p_notification_id),
132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),

132: object_version_number = nvl(p_object_version_number,0) + 1 ,
133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),

133: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE party_notification_id = p_party_notification_id

Line 138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

134: recipient_user_id = DECODE( p_recipient_user_id, null, recipient_user_id, FND_API.G_MISS_NUM, null, p_recipient_user_id),
135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE party_notification_id = p_party_notification_id
142: AND object_version_number = p_object_version_number;

Line 139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

135: notif_for_entity_id = DECODE( p_notif_for_entity_id, null, notif_for_entity_id, FND_API.G_MISS_NUM, null, p_notif_for_entity_id),
136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE party_notification_id = p_party_notification_id
142: AND object_version_number = p_object_version_number;
143:

Line 140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

136: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),
137: notif_type_code = DECODE( p_notif_type_code, null, notif_type_code, FND_API.g_miss_char, null, p_notif_type_code),
138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
139: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
141: WHERE party_notification_id = p_party_notification_id
142: AND object_version_number = p_object_version_number;
143:
144:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: DELETE FROM pv_ge_party_notifications
173: WHERE party_notification_id = p_party_notification_id
174: AND object_version_number = p_object_version_number;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: End If;
178: END Delete_Row ;
179:
180:

Line 214: RAISE FND_API.g_exc_error;

210: FETCH c INTO Recinfo;
211: IF (c%NOTFOUND) THEN
212: CLOSE c;
213: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
214: RAISE FND_API.g_exc_error;
215: END IF;
216: CLOSE c;
217: END Lock_Row;
218: