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.CZ_SECURITY_PVT dependencies on FND_MESSAGE

Line 3218: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');

3214: NULL;
3215: WHEN NO_FORCE_UNLOCK_PRIV THEN
3216: x_return_status := FND_API.G_RET_STS_ERROR;
3217: x_msg_count := 1;
3218: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3219: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3220: FND_MSG_PUB.ADD;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3222: WHEN MODEL_UNLOCK_ERR THEN

Line 3219: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);

3215: WHEN NO_FORCE_UNLOCK_PRIV THEN
3216: x_return_status := FND_API.G_RET_STS_ERROR;
3217: x_msg_count := 1;
3218: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3219: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3220: FND_MSG_PUB.ADD;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3222: WHEN MODEL_UNLOCK_ERR THEN
3223: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');

3221: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3222: WHEN MODEL_UNLOCK_ERR THEN
3223: x_return_status := FND_API.G_RET_STS_ERROR;
3224: x_msg_count := 1;
3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
3226: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3228: FND_MSG_PUB.ADD;
3229: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3226: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

3222: WHEN MODEL_UNLOCK_ERR THEN
3223: x_return_status := FND_API.G_RET_STS_ERROR;
3224: x_msg_count := 1;
3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
3226: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3228: FND_MSG_PUB.ADD;
3229: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3230: WHEN OTHERS THEN

Line 3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

3223: x_return_status := FND_API.G_RET_STS_ERROR;
3224: x_msg_count := 1;
3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
3226: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3228: FND_MSG_PUB.ADD;
3229: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3230: WHEN OTHERS THEN
3231: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3315: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');

3311: NULL;
3312: WHEN NO_FORCE_UNLOCK_PRIV THEN
3313: x_return_status := FND_API.G_RET_STS_ERROR;
3314: x_msg_count := 1;
3315: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3316: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3317: FND_MSG_PUB.ADD;
3318: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3319: WHEN TEMPLATE_UNLOCK_ERR THEN

Line 3316: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);

3312: WHEN NO_FORCE_UNLOCK_PRIV THEN
3313: x_return_status := FND_API.G_RET_STS_ERROR;
3314: x_msg_count := 1;
3315: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3316: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3317: FND_MSG_PUB.ADD;
3318: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3319: WHEN TEMPLATE_UNLOCK_ERR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');

3318: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3319: WHEN TEMPLATE_UNLOCK_ERR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: x_msg_count := 1;
3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3323: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3323: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);

3319: WHEN TEMPLATE_UNLOCK_ERR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: x_msg_count := 1;
3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3323: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3327: WHEN OTHERS THEN

Line 3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: x_msg_count := 1;
3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3323: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3327: WHEN OTHERS THEN
3328: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');

3421: WHEN TEMPLATEID_IS_NULL THEN
3422: NULL;
3423: WHEN TEMPLATE_IS_LOCKED THEN
3424: x_return_status := FND_API.G_RET_STS_ERROR;
3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;
3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);

Line 3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);

3422: NULL;
3423: WHEN TEMPLATE_IS_LOCKED THEN
3424: x_return_status := FND_API.G_RET_STS_ERROR;
3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;
3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
3430: WHEN OTHERS THEN

Line 3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);

3423: WHEN TEMPLATE_IS_LOCKED THEN
3424: x_return_status := FND_API.G_RET_STS_ERROR;
3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;
3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
3430: WHEN OTHERS THEN
3431: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3434: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');

3430: WHEN OTHERS THEN
3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3434: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3435: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
3436: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3437: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3438: END lock_template;

Line 3435: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);

3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3434: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3435: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
3436: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3437: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3438: END lock_template;
3439:

Line 3436: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3434: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3435: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
3436: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3437: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3438: END lock_template;
3439:
3440: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 3605: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');

3601: NULL;
3602: WHEN TEMPLATE_UNLOCK_ERR THEN
3603: x_return_status := FND_API.G_RET_STS_ERROR;
3604: x_msg_count := 1;
3605: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3606: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3608: FND_MSG_PUB.ADD;
3609: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3606: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);

3602: WHEN TEMPLATE_UNLOCK_ERR THEN
3603: x_return_status := FND_API.G_RET_STS_ERROR;
3604: x_msg_count := 1;
3605: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3606: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3608: FND_MSG_PUB.ADD;
3609: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3610: WHEN OTHERS THEN

Line 3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

3603: x_return_status := FND_API.G_RET_STS_ERROR;
3604: x_msg_count := 1;
3605: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3606: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3608: FND_MSG_PUB.ADD;
3609: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3610: WHEN OTHERS THEN
3611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3883: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');

3879: EXCEPTION
3880: WHEN INVALID_MODEL_ID THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: x_msg_count := 1;
3883: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3886: WHEN LOCK_SINGLE_MODEL_ERR THEN
3887: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');

3885: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3886: WHEN LOCK_SINGLE_MODEL_ERR THEN
3887: x_return_status := FND_API.G_RET_STS_ERROR;
3888: x_msg_count := 1;
3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');
3890: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3891: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3892: FND_MSG_PUB.ADD;
3893: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3890: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

3886: WHEN LOCK_SINGLE_MODEL_ERR THEN
3887: x_return_status := FND_API.G_RET_STS_ERROR;
3888: x_msg_count := 1;
3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');
3890: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3891: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3892: FND_MSG_PUB.ADD;
3893: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3894: WHEN NO_LOCKING_REQUIRED THEN

Line 3891: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

3887: x_return_status := FND_API.G_RET_STS_ERROR;
3888: x_msg_count := 1;
3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');
3890: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3891: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3892: FND_MSG_PUB.ADD;
3893: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3894: WHEN NO_LOCKING_REQUIRED THEN
3895: NULL;

Line 3905: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');

3901: IF (l_model_name_tbl.COUNT > 0) THEN
3902: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
3903: LOOP
3904: x_msg_count := x_msg_count + 1;
3905: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
3906: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
3907: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
3908: FND_MSG_PUB.ADD;
3909: END LOOP;

Line 3906: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));

3902: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
3903: LOOP
3904: x_msg_count := x_msg_count + 1;
3905: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
3906: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
3907: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
3908: FND_MSG_PUB.ADD;
3909: END LOOP;
3910: END IF;

Line 3907: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));

3903: LOOP
3904: x_msg_count := x_msg_count + 1;
3905: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
3906: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
3907: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
3908: FND_MSG_PUB.ADD;
3909: END LOOP;
3910: END IF;
3911: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3916: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');

3912: WHEN OTHERS THEN
3913: x_return_status := FND_API.G_RET_STS_ERROR;
3914: x_msg_count := 1;
3915: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3916: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3917: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
3918: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3919: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3920: END lock_model;

Line 3917: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);

3913: x_return_status := FND_API.G_RET_STS_ERROR;
3914: x_msg_count := 1;
3915: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3916: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3917: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
3918: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3919: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3920: END lock_model;
3921:

Line 3918: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

3914: x_msg_count := 1;
3915: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3916: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3917: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
3918: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3919: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3920: END lock_model;
3921:
3922: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 4073: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');

4069: IF (l_model_name_tbl.COUNT > 0) THEN
4070: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4071: LOOP
4072: x_msg_count := x_msg_count + 1;
4073: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4074: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4075: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4076: FND_MSG_PUB.ADD;
4077: END LOOP;

Line 4074: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));

4070: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4071: LOOP
4072: x_msg_count := x_msg_count + 1;
4073: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4074: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4075: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4076: FND_MSG_PUB.ADD;
4077: END LOOP;
4078: END IF;

Line 4075: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));

4071: LOOP
4072: x_msg_count := x_msg_count + 1;
4073: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4074: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4075: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4076: FND_MSG_PUB.ADD;
4077: END LOOP;
4078: END IF;
4079: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 4521: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');

4517: EXCEPTION
4518: WHEN INVALID_MODEL_ID THEN
4519: x_return_status := FND_API.G_RET_STS_ERROR;
4520: x_msg_count := 1;
4521: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');
4522: FND_MSG_PUB.ADD;
4523: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4524: WHEN NO_LOCKING_REQUIRED THEN
4525: NULL;

Line 4535: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');

4531: IF (l_model_name_tbl.COUNT > 0) THEN
4532: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4533: LOOP
4534: x_msg_count := x_msg_count + 1;
4535: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
4536: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4537: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
4538: FND_MSG_PUB.ADD;
4539: END LOOP;

Line 4536: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));

4532: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4533: LOOP
4534: x_msg_count := x_msg_count + 1;
4535: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
4536: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4537: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
4538: FND_MSG_PUB.ADD;
4539: END LOOP;
4540: END IF;

Line 4537: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));

4533: LOOP
4534: x_msg_count := x_msg_count + 1;
4535: FND_MESSAGE.SET_NAME('CZ', 'CZ_LOCK_MODEL_ERR');
4536: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4537: FND_MESSAGE.SET_TOKEN('USERNAME',l_checkout_user_tbl(i));
4538: FND_MSG_PUB.ADD;
4539: END LOOP;
4540: END IF;
4541: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 4546: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');

4542: WHEN OTHERS THEN
4543: x_return_status := FND_API.G_RET_STS_ERROR;
4544: x_msg_count := 1;
4545: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4546: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4547: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
4548: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4549: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4550: END lock_pub_model; /* end lock_pub_model */

Line 4547: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);

4543: x_return_status := FND_API.G_RET_STS_ERROR;
4544: x_msg_count := 1;
4545: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4546: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4547: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
4548: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4549: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4550: END lock_pub_model; /* end lock_pub_model */
4551:

Line 4548: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

4544: x_msg_count := 1;
4545: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4546: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4547: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);
4548: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4549: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4550: END lock_pub_model; /* end lock_pub_model */
4551:
4552: ---------------------------------------------------->>>>>>>>>>>>>>>>>>

Line 4680: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');

4676: IF (l_model_name_tbl.COUNT > 0) THEN
4677: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4678: LOOP
4679: x_msg_count := x_msg_count + 1;
4680: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4681: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4682: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4683: FND_MSG_PUB.ADD;
4684: END LOOP;

Line 4681: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));

4677: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4678: LOOP
4679: x_msg_count := x_msg_count + 1;
4680: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4681: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4682: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4683: FND_MSG_PUB.ADD;
4684: END LOOP;
4685: END IF;

Line 4682: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));

4678: LOOP
4679: x_msg_count := x_msg_count + 1;
4680: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
4681: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name_tbl(i));
4682: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(i));
4683: FND_MSG_PUB.ADD;
4684: END LOOP;
4685: END IF;
4686: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');

4836: WHEN TEMPLATEID_IS_NULL THEN
4837: NULL;
4838: WHEN TEMPLATE_IS_LOCKED THEN
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;
4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);

Line 4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);

4837: NULL;
4838: WHEN TEMPLATE_IS_LOCKED THEN
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;
4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
4845: WHEN OTHERS THEN

Line 4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);

4838: WHEN TEMPLATE_IS_LOCKED THEN
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;
4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
4845: WHEN OTHERS THEN
4846: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4849: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');

4845: WHEN OTHERS THEN
4846: x_return_status := FND_API.G_RET_STS_ERROR;
4847: x_msg_count := 1;
4848: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
4849: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4850: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
4851: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4852: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4853: END;

Line 4850: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);

4846: x_return_status := FND_API.G_RET_STS_ERROR;
4847: x_msg_count := 1;
4848: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
4849: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4850: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
4851: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4852: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4853: END;
4854:

Line 4851: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

4847: x_msg_count := 1;
4848: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
4849: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4850: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);
4851: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4852: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4853: END;
4854:
4855: IF (p_commit_flag = FND_API.G_TRUE) THEN

Line 4978: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');

4974: NULL;
4975: WHEN TEMPLATE_UNLOCK_ERR THEN
4976: x_return_status := FND_API.G_RET_STS_ERROR;
4977: x_msg_count := 1;
4978: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
4979: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
4981: FND_MSG_PUB.ADD;
4982: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 4979: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);

4975: WHEN TEMPLATE_UNLOCK_ERR THEN
4976: x_return_status := FND_API.G_RET_STS_ERROR;
4977: x_msg_count := 1;
4978: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
4979: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
4981: FND_MSG_PUB.ADD;
4982: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4983: WHEN OTHERS THEN

Line 4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

4976: x_return_status := FND_API.G_RET_STS_ERROR;
4977: x_msg_count := 1;
4978: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
4979: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
4981: FND_MSG_PUB.ADD;
4982: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4983: WHEN OTHERS THEN
4984: x_return_status := FND_API.G_RET_STS_ERROR;