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

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62:
63: l_object_version_number := nvl(p_object_version_number, 1);
64:
65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: INSERT INTO pv_TAP_ACCESS_TERRS(
69: partner_access_id,
70: terr_id,

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

78: program_application_id,
79: program_id,
80: program_update_date
81: ) VALUES (
82: DECODE( p_partner_access_id, FND_API.G_MISS_NUM, NULL, p_partner_access_id),
83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),

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

79: program_id,
80: program_update_date
81: ) VALUES (
82: DECODE( p_partner_access_id, FND_API.G_MISS_NUM, NULL, p_partner_access_id),
83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),

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

80: program_update_date
81: ) VALUES (
82: DECODE( p_partner_access_id, FND_API.G_MISS_NUM, NULL, p_partner_access_id),
83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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 85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

81: ) VALUES (
82: DECODE( p_partner_access_id, FND_API.G_MISS_NUM, NULL, p_partner_access_id),
83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),

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

82: DECODE( p_partner_access_id, FND_API.G_MISS_NUM, NULL, p_partner_access_id),
83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

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

83: DECODE( p_terr_id, FND_API.G_MISS_NUM, NULL, p_terr_id),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

Line 88: 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),

84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

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

85: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));

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

86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));
94:

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

87: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));
94:
95: EXCEPTION

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

88: 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),
89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));
94:
95: EXCEPTION
96: WHEN OTHERS THEN

Line 93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));

89: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
90: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
91: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
92: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
93: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date));
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: ROLLBACK TO Insert_PAccesses_Row;

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: -- Standard Start of API savepoint
135: SAVEPOINT Update_TAccesses_Row;
136:
137: -- Initialize API return status to SUCCESS
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: Update PV_TAP_ACCESS_TERRS
141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),

Line 142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),

138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: Update PV_TAP_ACCESS_TERRS
141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),

139:
140: Update PV_TAP_ACCESS_TERRS
141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,

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

140: Update PV_TAP_ACCESS_TERRS
141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),

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

141: SET
142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),

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

142: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
143: terr_id = DECODE( p_terr_id, null, terr_id, FND_API.G_MISS_NUM, null, p_terr_id),
144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
150: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

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

144: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
150: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
151: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date)
152: WHERE partner_access_id = p_partner_access_id

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

145: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
150: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
151: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date)
152: WHERE partner_access_id = p_partner_access_id
153: AND terr_id = p_terr_id

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

146: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
150: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
151: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date)
152: WHERE partner_access_id = p_partner_access_id
153: AND terr_id = p_terr_id
154: AND object_version_number = p_object_version_number;

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

147: object_version_number = nvl(p_object_version_number,0) + 1 ,
148: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
149: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
150: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
151: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date)
152: WHERE partner_access_id = p_partner_access_id
153: AND terr_id = p_terr_id
154: AND object_version_number = p_object_version_number;
155:

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: AND object_version_number = p_object_version_number;
155:
156:
157: IF (SQL%NOTFOUND) THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END IF;
160:
161: EXCEPTION
162:

Line 163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

159: END IF;
160:
161: EXCEPTION
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO Update_TAccesses_Row;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161: EXCEPTION
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO Update_TAccesses_Row;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
168: THEN
169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

170: END IF;
171:
172: WHEN OTHERS THEN
173: ROLLBACK TO Update_TAccesses_Row;
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175:
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: -- Standard Start of API savepoint
208: SAVEPOINT Delete_TAccesses_Row;
209:
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: DELETE FROM PV_TAP_ACCESS_TERRS
214: WHERE partner_access_id = p_partner_access_id
215: AND terr_id = p_terr_id

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: WHERE partner_access_id = p_partner_access_id
215: AND terr_id = p_terr_id
216: AND object_version_number = p_object_version_number;
217: If (SQL%NOTFOUND) then
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: End If;
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: End If;
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO Delete_TAccesses_Row;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225:
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO Delete_TAccesses_Row;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225:
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: WHEN OTHERS THEN
231: ROLLBACK TO Delete_TAccesses_Row;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233:
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: -- Standard Start of API savepoint
273: SAVEPOINT Lock_TAccesses_Row;
274:
275: -- Initialize API return status to SUCCESS
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: OPEN c;
279: FETCH c INTO Recinfo;
280: IF (c%NOTFOUND) THEN

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: FETCH c INTO Recinfo;
280: IF (c%NOTFOUND) THEN
281: CLOSE c;
282: PVX_Utility_PVT.error_message ('PV_API_RECORD_NOT_FOUND');
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: CLOSE c;
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: CLOSE c;
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO Lock_TAccesses_Row;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285: CLOSE c;
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO Lock_TAccesses_Row;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
294: END IF;
295: WHEN OTHERS THEN
296: ROLLBACK TO Lock_TAccesses_Row;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);