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

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60:
61: l_object_version_number := nvl(p_object_version_number, 1);
62:
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67: INSERT INTO PV_TAP_BATCH_CHG_PARTNERS(
68: partner_id,

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

78: program_update_date,
79: processed_flag,
80: vad_partner_id
81: ) VALUES (
82: DECODE( px_partner_id, FND_API.G_MISS_NUM, NULL,NULL,NULL, px_partner_id),
83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),

Line 83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),

79: processed_flag,
80: vad_partner_id
81: ) VALUES (
82: DECODE( px_partner_id, FND_API.G_MISS_NUM, NULL,NULL,NULL, px_partner_id),
83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),

80: vad_partner_id
81: ) VALUES (
82: DECODE( px_partner_id, FND_API.G_MISS_NUM, NULL,NULL,NULL, px_partner_id),
83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),

Line 85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),

81: ) VALUES (
82: DECODE( px_partner_id, FND_API.G_MISS_NUM, NULL,NULL,NULL, px_partner_id),
83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

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

82: DECODE( px_partner_id, FND_API.G_MISS_NUM, NULL,NULL,NULL, px_partner_id),
83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

Line 87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

83: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

Line 88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),

84: DECODE( p_last_update_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_update_by),
85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

Line 89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

85: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),

Line 90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),
94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));

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

87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),
94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));
95:

Line 92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

88: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),
94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));
95:
96: EXCEPTION

Line 93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),

89: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),
94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));
95:
96: EXCEPTION
97: WHEN OTHERS THEN

Line 94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));

90: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
91: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
92: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
93: DECODE( p_processed_flag, FND_API.g_miss_char, 'P', p_processed_flag),
94: DECODE( p_vad_partner_id, FND_API.g_miss_num, null, NULL, NULL, p_vad_partner_id));
95:
96: EXCEPTION
97: WHEN OTHERS THEN
98: ROLLBACK TO Insert_Chng_Partner_Row;

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

95:
96: EXCEPTION
97: WHEN OTHERS THEN
98: ROLLBACK TO Insert_Chng_Partner_Row;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100:
101: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
102: THEN
103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: -- Standard Start of API savepoint
142: SAVEPOINT Update_Chng_Partner_Row;
143:
144: -- Initialize API return status to SUCCESS
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: Update PV_TAP_BATCH_CHG_PARTNERS
148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

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

145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: Update PV_TAP_BATCH_CHG_PARTNERS
148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,

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

146:
147: Update PV_TAP_BATCH_CHG_PARTNERS
148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),

Line 151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),

147: Update PV_TAP_BATCH_CHG_PARTNERS
148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),

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

148: SET
149: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

Line 154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),

150: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),

Line 155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),

151: last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),
159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)

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

152: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),
159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)
160: WHERE partner_id = p_partner_id

Line 157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),

153: object_version_number = nvl(p_object_version_number,0) + 1 ,
154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),
159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)
160: WHERE partner_id = p_partner_id
161: AND object_version_number = p_object_version_number;

Line 158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),

154: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),
159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)
160: WHERE partner_id = p_partner_id
161: AND object_version_number = p_object_version_number;
162:

Line 159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)

155: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
156: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
157: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
158: processed_flag = DECODE( p_processed_flag, null, processed_flag, FND_API.g_miss_char, null, p_processed_flag),
159: vad_partner_id = DECODE( p_vad_partner_id,null,null,FND_API.g_miss_num, NULL, p_vad_partner_id)
160: WHERE partner_id = p_partner_id
161: AND object_version_number = p_object_version_number;
162:
163:

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: AND object_version_number = p_object_version_number;
162:
163:
164: IF (SQL%NOTFOUND) THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: EXCEPTION
169:

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: END IF;
167:
168: EXCEPTION
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Update_Chng_Partner_Row;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: EXCEPTION
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Update_Chng_Partner_Row;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: END IF;
178:
179: WHEN OTHERS THEN
180: ROLLBACK TO Update_Chng_Partner_Row;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: -- Standard Start of API savepoint
213: SAVEPOINT Delete_Chng_Partner_Row;
214:
215: -- Initialize API return status to SUCCESS
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: DELETE FROM PV_TAP_BATCH_CHG_PARTNERS
219: WHERE partner_id = p_partner_id
220: AND object_version_number = p_object_version_number;

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: DELETE FROM PV_TAP_BATCH_CHG_PARTNERS
219: WHERE partner_id = p_partner_id
220: AND object_version_number = p_object_version_number;
221: If (SQL%NOTFOUND) then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: End If;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: End If;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Delete_Chng_Partner_Row;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Delete_Chng_Partner_Row;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: END IF;
234:
235: WHEN OTHERS THEN
236: ROLLBACK TO Delete_Chng_Partner_Row;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: -- Standard Start of API savepoint
279: SAVEPOINT Lock_Chng_Partner_Row;
280:
281: -- Initialize API return status to SUCCESS
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: OPEN c;
285: FETCH c INTO Recinfo;
286: IF (c%NOTFOUND) THEN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: FETCH c INTO Recinfo;
286: IF (c%NOTFOUND) THEN
287: CLOSE c;
288: PVX_Utility_PVT.error_message ('PV_API_RECORD_NOT_FOUND');
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: CLOSE c;
292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291: CLOSE c;
292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO Lock_Chng_Partner_Row;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291: CLOSE c;
292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO Lock_Chng_Partner_Row;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
300: END IF;
301: WHEN OTHERS THEN
302: ROLLBACK TO Lock_Chng_Partner_Row;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);