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_MSG_PUB

Line 3143: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3139: x_msg_data := NULL;
3140: x_msg_count := 0;
3141:
3142: ----initialize the message stack depending on the input parameter
3143: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3144:
3145: ----check if the input parameter p_model_id is NULL
3146: ----if it is NULL raise an exception
3147: IF (p_model_id IS NULL) THEN

Line 3220: FND_MSG_PUB.ADD;

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;
3224: x_msg_count := 1;

Line 3221: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3224: x_msg_count := 1;
3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');

Line 3228: FND_MSG_PUB.ADD;

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;
3232: x_msg_count := 1;

Line 3229: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3232: x_msg_count := 1;
3233: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);

Line 3235: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: x_msg_count := 1;
3233: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3234: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
3235: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3236: END force_unlock_model;
3237:
3238: --------------------
3239: /*#

Line 3281: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3277: x_msg_data := NULL;
3278: x_msg_count := 0;
3279:
3280: ----initialize the message stack depending on the input parameter
3281: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3282:
3283: ----check if the input parameter p_template_id is NULL
3284: ----if it is NULL raise an exception
3285: IF (p_template_id IS NULL) THEN

Line 3317: FND_MSG_PUB.ADD;

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;
3321: x_msg_count := 1;

Line 3318: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3321: x_msg_count := 1;
3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');

Line 3325: FND_MSG_PUB.ADD;

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;
3329: x_msg_count := 1;

Line 3326: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3329: x_msg_count := 1;
3330: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);

Line 3332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3328: x_return_status := FND_API.G_RET_STS_ERROR;
3329: x_msg_count := 1;
3330: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3331: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3333: END force_unlock_template;
3334:
3335: --------------------
3336: /*#

Line 3379: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3375: x_msg_data := NULL;
3376: x_msg_count := 0;
3377:
3378: ----initialize the message stack depending on the input parameter
3379: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3380:
3381: ----check if locking is enabled
3382: ----if the site level profile for locking is not enabled then
3383: ----there is no need to do locking

Line 3428: FND_MSG_PUB.ADD;

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;
3432: x_msg_count := 1;

Line 3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);

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;
3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);

Line 3437: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3441: /*#

Line 3479: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3475:
3476: x_return_status := FND_API.G_RET_STS_SUCCESS;
3477:
3478: ----initialize the message stack depending on the input parameter
3479: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3480:
3481: -----check if the input parameter p_template_id
3482: -----has a value
3483: IF (p_templates_to_lock.COUNT = 0) THEN

Line 3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data,p_encoded => FND_API.G_FALSE);

3514: END IF;
3515: END IF;
3516: END LOOP;
3517: END IF;
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data,p_encoded => FND_API.G_FALSE);
3519: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */
3520: EXCEPTION
3521: WHEN NO_TEMPLATES_IDS THEN
3522: NULL;

Line 3527: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

3523: WHEN OTHERS THEN
3524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3525: x_return_status := SQLERRM;
3526: x_msg_count := 1;
3527: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3528: END lock_template;
3529:
3530: ------------------------------
3531: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 3570: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3566: x_return_status := FND_API.G_RET_STS_SUCCESS;
3567: x_msg_count := 0;
3568: x_msg_data := NULL;
3569: ----initialize the message stack depending on the input parameter
3570: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3571:
3572: -----check if the input parameter p_template_id
3573: -----has a value
3574: IF (p_template_id IS NULL) THEN

Line 3608: FND_MSG_PUB.ADD;

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;
3612: x_msg_count := 1;

Line 3609: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3612: x_msg_count := 1;
3613: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);

Line 3615: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3611: x_return_status := FND_API.G_RET_STS_ERROR;
3612: x_msg_count := 1;
3613: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3614: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3615: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3616: END unlock_template;
3617:
3618: ----------------------
3619: PROCEDURE unlock_template(p_api_version IN NUMBER,

Line 3636: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3632:
3633: x_return_status := FND_API.G_RET_STS_SUCCESS;
3634: x_msg_count := 0;
3635: ----initialize the message stack depending on the input parameter
3636: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3637:
3638: -----check if the input parameter p_template_id
3639: -----has a value
3640: IF (p_templates_to_unlock.COUNT = 0) THEN

Line 3658: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655: END IF;
3656: END LOOP;
3657: END IF;
3658: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3659: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */
3660: EXCEPTION
3661: WHEN NO_TEMPLATES_IDS THEN
3662: NULL;

Line 3667: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

3663: WHEN OTHERS THEN
3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: x_return_status := SQLERRM;
3666: x_msg_count := 1;
3667: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3668: END unlock_template;
3669:
3670: ---------------------
3671: /*#

Line 3767: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3763: x_msg_count := 0;
3764: x_locked_entities.DELETE;
3765:
3766: ----initialize the message stack depending on the input parameter
3767: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3768:
3769: ----check if locking is enabled
3770: ----if the site level profile for locking is not enabled then
3771: ----there is no need to do locking

Line 3884: FND_MSG_PUB.ADD;

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;
3888: x_msg_count := 1;

Line 3885: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3888: x_msg_count := 1;
3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');

Line 3892: FND_MSG_PUB.ADD;

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;
3896: WHEN MODELID_IS_NULL THEN

Line 3893: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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;
3896: WHEN MODELID_IS_NULL THEN
3897: NULL;

Line 3908: FND_MSG_PUB.ADD;

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);
3912: WHEN OTHERS THEN

Line 3911: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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);
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);

Line 3919: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3923: /*#

Line 3972: FND_MSG_PUB.initialize;

3968: BEGIN
3969: ----initialize FND stack
3970: x_return_status := FND_API.G_RET_STS_SUCCESS;
3971: IF (p_init_msg_list = FND_API.G_TRUE) THEN
3972: FND_MSG_PUB.initialize;
3973: END IF;
3974:
3975: IF (p_models_to_unlock.COUNT > 0) THEN
3976: FOR I IN p_models_to_unlock.FIRST..p_models_to_unlock.LAST

Line 3986: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

3982: END IF;
3983: END LOOP;
3984: END IF;
3985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3986: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3987: END IF;
3988: IF (p_commit_flag = FND_API.G_TRUE) THEN
3989: COMMIT;
3990: END IF;

Line 4023: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

4019: x_msg_data := NULL;
4020: x_msg_count := 0;
4021:
4022: ----initialize the message stack depending on the input parameter
4023: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
4024:
4025: -----check if the input parameter p_model_id
4026: -----has a value
4027: IF (p_model_id IS NULL) THEN

Line 4076: FND_MSG_PUB.ADD;

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);
4080: WHEN OTHERS THEN

Line 4079: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

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);
4080: WHEN OTHERS THEN
4081: x_return_status := FND_API.G_RET_STS_ERROR;
4082: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4083: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);

Line 4084: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4080: WHEN OTHERS THEN
4081: x_return_status := FND_API.G_RET_STS_ERROR;
4082: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4083: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
4084: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4085: END unlock_model;
4086: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4087: ------wrappers
4088:

Line 4200: FND_MSG_PUB.initialize;

4196: IS
4197:
4198: BEGIN
4199: ----initialize FND stack
4200: FND_MSG_PUB.initialize;
4201: x_return_status := FND_API.G_RET_STS_SUCCESS;
4202: x_msg_data := NULL;
4203: x_msg_count := 0;
4204:

Line 4227: FND_MSG_PUB.initialize;

4223: l_return_status VARCHAR2(1);
4224: BEGIN
4225: x_return_status := FND_API.G_RET_STS_SUCCESS;
4226: IF (p_init_msg_list = FND_API.G_TRUE) THEN
4227: FND_MSG_PUB.initialize;
4228: x_msg_data := NULL;
4229: x_msg_count := 0;
4230: END IF;
4231:

Line 4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244: END IF;
4245: END LOOP;
4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4248: END IF;
4249: END IF;
4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
4251: EXCEPTION

Line 4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
4251: EXCEPTION
4252: WHEN OTHERS THEN
4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4256: END;
4257:
4258: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

4251: EXCEPTION
4252: WHEN OTHERS THEN
4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4256: END;
4257:
4258: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4259: END cz_security_pvt;