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_PTNR_RESPS_PKG dependencies on FND_API

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

78: last_updated_by,
79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_ptnr_resp_id, FND_API.G_MISS_NUM, NULL, px_ptnr_resp_id),
83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),

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

79: last_update_date,
80: last_update_login
81: ) VALUES (
82: DECODE( px_ptnr_resp_id, FND_API.G_MISS_NUM, NULL, px_ptnr_resp_id),
83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),

Line 84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),

80: last_update_login
81: ) VALUES (
82: DECODE( px_ptnr_resp_id, FND_API.G_MISS_NUM, NULL, px_ptnr_resp_id),
83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),

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

81: ) VALUES (
82: DECODE( px_ptnr_resp_id, FND_API.G_MISS_NUM, NULL, px_ptnr_resp_id),
83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

82: DECODE( px_ptnr_resp_id, FND_API.G_MISS_NUM, NULL, px_ptnr_resp_id),
83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
90: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

83: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),

84: DECODE( p_user_role_code, FND_API.g_miss_char, NULL, p_user_role_code),
85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

85: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
86: DECODE( p_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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_responsibility_id, FND_API.G_MISS_NUM, NULL, p_responsibility_id),
87: DECODE( p_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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_source_resp_map_rule_id, FND_API.G_MISS_NUM, NULL, p_source_resp_map_rule_id),
88: DECODE( p_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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_resp_type_code, FND_API.g_miss_char, NULL, p_resp_type_code),
89: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
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: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),

126: IS
127: BEGIN
128: Update pv_ge_ptnr_resps
129: SET
130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),

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

127: BEGIN
128: Update pv_ge_ptnr_resps
129: SET
130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),

Line 132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),

128: Update pv_ge_ptnr_resps
129: SET
130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),

Line 133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

129: SET
130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),

130: ptnr_resp_id = DECODE( p_ptnr_resp_id, null, ptnr_resp_id, FND_API.G_MISS_NUM, null, p_ptnr_resp_id),
131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),

131: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),

132: user_role_code = DECODE( p_user_role_code, null, user_role_code, FND_API.g_miss_char, null, p_user_role_code),
133: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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 138: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

134: responsibility_id = DECODE( p_responsibility_id, null, responsibility_id, FND_API.G_MISS_NUM, null, p_responsibility_id),
135: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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 ptnr_resp_id = p_ptnr_resp_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: source_resp_map_rule_id = DECODE( p_source_resp_map_rule_id, null, source_resp_map_rule_id, FND_API.G_MISS_NUM, null, p_source_resp_map_rule_id),
136: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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 ptnr_resp_id = p_ptnr_resp_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: resp_type_code = DECODE( p_resp_type_code, null, resp_type_code, FND_API.g_miss_char, null, p_resp_type_code),
137: object_version_number = nvl(p_object_version_number,0) + 1 ,
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 ptnr_resp_id = p_ptnr_resp_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_ptnr_resps
173: WHERE ptnr_resp_id = p_ptnr_resp_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: