DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on FND_API

Line 1672: ,p_message_type => FND_API.G_RET_STS_ERROR

1668: ERROR_HANDLER.Add_Error_Message
1669: (
1670: p_message_text => l_msg_text
1671: ,p_application_id => 'EGO'
1672: ,p_message_type => FND_API.G_RET_STS_ERROR
1673: ,p_row_identifier => i.TRANSACTION_ID
1674: ,p_entity_id => p_entity_id
1675: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1676: ,p_entity_code => p_entity_code

Line 1687: ,p_message_type => FND_API.G_RET_STS_ERROR

1683: ERROR_HANDLER.Add_Error_Message
1684: (
1685: p_message_text => l_msg_text
1686: ,p_application_id => 'EGO'
1687: ,p_message_type => FND_API.G_RET_STS_ERROR
1688: ,p_row_identifier => i.TRANSACTION_ID
1689: ,p_entity_id => p_entity_id
1690: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1691: ,p_entity_code => p_entity_code

Line 1740: ,p_message_type => FND_API.G_RET_STS_ERROR

1736: ERROR_HANDLER.Add_Error_Message
1737: (
1738: p_message_text => l_msg_text
1739: ,p_application_id => 'EGO'
1740: ,p_message_type => FND_API.G_RET_STS_ERROR
1741: ,p_row_identifier => i.TRANSACTION_ID
1742: ,p_entity_id => p_entity_id
1743: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1744: ,p_entity_code => p_entity_code

Line 1755: ,p_message_type => FND_API.G_RET_STS_ERROR

1751: ERROR_HANDLER.Add_Error_Message
1752: (
1753: p_message_text => l_msg_text
1754: ,p_application_id => 'EGO'
1755: ,p_message_type => FND_API.G_RET_STS_ERROR
1756: ,p_row_identifier => i.TRANSACTION_ID
1757: ,p_entity_id => p_entity_id
1758: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
1759: ,p_entity_code => p_entity_code

Line 3648: FND_API.G_FALSE,

3644: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
3645: i.INVENTORY_ITEM_ID,
3646: i.ORGANIZATION_ID,
3647: l_attribute_names,
3648: FND_API.G_FALSE,
3649: l_return_status,
3650: l_msg_count,
3651: l_msg_data);
3652:

Line 3659: ,p_message_type => FND_API.G_RET_STS_ERROR

3655: ERROR_HANDLER.Add_Error_Message
3656: (
3657: p_message_text => l_msg_data
3658: ,p_application_id => 'EGO'
3659: ,p_message_type => FND_API.G_RET_STS_ERROR
3660: ,p_row_identifier => i.TRANSACTION_ID
3661: ,p_entity_id => p_entity_id
3662: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3663: ,p_entity_code => p_entity_code

Line 3696: ,p_message_type => FND_API.G_RET_STS_ERROR

3692: ERROR_HANDLER.Add_Error_Message
3693: (
3694: p_message_text => l_msg_data
3695: ,p_application_id => 'EGO'
3696: ,p_message_type => FND_API.G_RET_STS_ERROR
3697: ,p_row_identifier => i.TRANSACTION_ID
3698: ,p_entity_id => p_entity_id
3699: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3700: ,p_entity_code => p_entity_code

Line 3726: FND_API.G_FALSE,

3722: i.INVENTORY_ITEM_ID,
3723: i.ORGANIZATION_ID,
3724: l_attribute_names,
3725: i.ATTR_GROUP_INT_NAME,
3726: FND_API.G_FALSE,
3727: l_return_status,
3728: l_msg_count,
3729: l_msg_data);
3730:

Line 3737: ,p_message_type => FND_API.G_RET_STS_ERROR

3733: ERROR_HANDLER.Add_Error_Message
3734: (
3735: p_message_text => l_msg_data
3736: ,p_application_id => 'EGO'
3737: ,p_message_type => FND_API.G_RET_STS_ERROR
3738: ,p_row_identifier => i.TRANSACTION_ID
3739: ,p_entity_id => p_entity_id
3740: ,p_table_name => 'EGO_ITM_USR_ATTR_INTRFC'
3741: ,p_entity_code => p_entity_code

Line 3788: ,p_validate_hierarchy => FND_API.G_FALSE

3784: ,p_object_name => 'EGO_ITEM'
3785: ,p_application_id => 431
3786: ,p_attr_group_type => 'EGO_ITEM_GTIN_MULTI_ATTRS'
3787: ,p_attr_group_name => p_attr_group_name
3788: ,p_validate_hierarchy => FND_API.G_FALSE
3789: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
3790: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
3791: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
3792: ,p_extension_id => p_extension_id

Line 3798: ,p_init_fnd_msg_list => FND_API.G_TRUE

3794: ,p_entity_id => G_ENTITY_ID
3795: ,p_entity_index => G_ENTITY_INDEX
3796: ,p_entity_code => G_ENTITY_CODE
3797: ,p_mode => l_mode
3798: ,p_init_fnd_msg_list => FND_API.G_TRUE
3799: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
3800: ,p_commit => FND_API.G_FALSE
3801: ,x_return_status => l_return_status
3802: ,x_errorcode => l_errorcode

Line 3799: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

3795: ,p_entity_index => G_ENTITY_INDEX
3796: ,p_entity_code => G_ENTITY_CODE
3797: ,p_mode => l_mode
3798: ,p_init_fnd_msg_list => FND_API.G_TRUE
3799: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
3800: ,p_commit => FND_API.G_FALSE
3801: ,x_return_status => l_return_status
3802: ,x_errorcode => l_errorcode
3803: ,x_msg_count => l_msg_count

Line 3800: ,p_commit => FND_API.G_FALSE

3796: ,p_entity_code => G_ENTITY_CODE
3797: ,p_mode => l_mode
3798: ,p_init_fnd_msg_list => FND_API.G_TRUE
3799: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
3800: ,p_commit => FND_API.G_FALSE
3801: ,x_return_status => l_return_status
3802: ,x_errorcode => l_errorcode
3803: ,x_msg_count => l_msg_count
3804: ,x_msg_data => l_msg_data

Line 3832: ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE

3828: ,p_inventory_item_id IN NUMBER
3829: ,p_organization_id IN NUMBER
3830: ,p_single_row_attrs_rec IN EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
3831: ,p_multi_row_attrs_table IN EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
3832: ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE
3833: ,p_entity_id IN NUMBER DEFAULT NULL
3834: ,p_entity_index IN NUMBER DEFAULT NULL
3835: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3836: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

Line 3836: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

3832: ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE
3833: ,p_entity_id IN NUMBER DEFAULT NULL
3834: ,p_entity_index IN NUMBER DEFAULT NULL
3835: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3836: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
3837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3838: ,x_return_status OUT NOCOPY VARCHAR2
3839: ,x_errorcode OUT NOCOPY NUMBER
3840: ,x_msg_count OUT NOCOPY NUMBER

Line 3837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

3833: ,p_entity_id IN NUMBER DEFAULT NULL
3834: ,p_entity_index IN NUMBER DEFAULT NULL
3835: ,p_entity_code IN VARCHAR2 DEFAULT NULL
3836: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
3837: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
3838: ,x_return_status OUT NOCOPY VARCHAR2
3839: ,x_errorcode OUT NOCOPY NUMBER
3840: ,x_msg_count OUT NOCOPY NUMBER
3841: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3989: IF FND_API.To_Boolean(p_init_error_handler) THEN

3985: RETURN l_row_id;
3986: END Create_Attrs_Row_Table;
3987:
3988: BEGIN
3989: IF FND_API.To_Boolean(p_init_error_handler) THEN
3990: ERROR_HANDLER.Initialize;
3991: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
3992: Debug_Msg('Initialized error handler');
3993: END IF;

Line 4148: ,p_message_type => FND_API.G_RET_STS_ERROR

4144: ERROR_HANDLER.Add_Error_Message
4145: (
4146: p_message_text => l_msg_text
4147: ,p_application_id => 'EGO'
4148: ,p_message_type => FND_API.G_RET_STS_ERROR
4149: ,p_row_identifier => p_inventory_item_id
4150: ,p_entity_id => p_entity_id
4151: ,p_entity_index => p_entity_index
4152: ,p_entity_code => p_entity_code

Line 4162: ,p_message_type => FND_API.G_RET_STS_ERROR

4158: ERROR_HANDLER.Add_Error_Message
4159: (
4160: p_message_text => l_msg_text
4161: ,p_application_id => 'EGO'
4162: ,p_message_type => FND_API.G_RET_STS_ERROR
4163: ,p_row_identifier => p_inventory_item_id
4164: ,p_entity_id => p_entity_id
4165: ,p_entity_index => p_entity_index
4166: ,p_entity_code => p_entity_code

Line 4170: IF (FND_API.To_Boolean(p_init_error_handler)) THEN

4166: ,p_entity_code => p_entity_code
4167: );
4168: END IF; -- IF l_msg_count
4169:
4170: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
4171: ERROR_HANDLER.Log_Error
4172: (p_write_err_to_inttable => 'Y'
4173: ,p_write_err_to_conclog => 'N'
4174: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

Line 5895: ,p_validate_hierarchy => FND_API.G_FALSE

5891: ,p_organization_id => p_organization_id
5892: ,p_attributes_row_table => l_attributes_row_table
5893: ,p_attributes_data_table => l_attributes_data_table
5894: ,p_do_policy_check => p_check_policy
5895: ,p_validate_hierarchy => FND_API.G_FALSE
5896: ,p_entity_id => p_entity_id
5897: ,p_entity_index => p_entity_index
5898: ,p_entity_code => p_entity_code
5899: ,p_init_error_handler => p_init_error_handler

Line 5900: ,p_init_fnd_msg_list => FND_API.G_FALSE

5896: ,p_entity_id => p_entity_id
5897: ,p_entity_index => p_entity_index
5898: ,p_entity_code => p_entity_code
5899: ,p_init_error_handler => p_init_error_handler
5900: ,p_init_fnd_msg_list => FND_API.G_FALSE
5901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
5902: ,p_commit => FND_API.G_FALSE
5903: ,x_failed_row_id_list => l_failed_row_id_list
5904: ,x_return_status => l_return_status

Line 5901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

5897: ,p_entity_index => p_entity_index
5898: ,p_entity_code => p_entity_code
5899: ,p_init_error_handler => p_init_error_handler
5900: ,p_init_fnd_msg_list => FND_API.G_FALSE
5901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
5902: ,p_commit => FND_API.G_FALSE
5903: ,x_failed_row_id_list => l_failed_row_id_list
5904: ,x_return_status => l_return_status
5905: ,x_errorcode => l_errorcode

Line 5902: ,p_commit => FND_API.G_FALSE

5898: ,p_entity_code => p_entity_code
5899: ,p_init_error_handler => p_init_error_handler
5900: ,p_init_fnd_msg_list => FND_API.G_FALSE
5901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
5902: ,p_commit => FND_API.G_FALSE
5903: ,x_failed_row_id_list => l_failed_row_id_list
5904: ,x_return_status => l_return_status
5905: ,x_errorcode => l_errorcode
5906: ,x_msg_count => l_msg_count

Line 6488: FND_API.G_FALSE,

6484: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
6485: p_inventory_item_id,
6486: p_organization_id,
6487: l_attribute_names,
6488: FND_API.G_FALSE,
6489: l_return_status,
6490: l_msg_count,
6491: l_msg_data);
6492:

Line 6496: IF FND_API.To_Boolean(p_init_error_handler) THEN

6492:
6493: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES with status='||l_return_status);
6494: IF l_return_status <> 'S' THEN
6495: Debug_Msg('Error msg - '|| l_msg_data);
6496: IF FND_API.To_Boolean(p_init_error_handler) THEN
6497: ERROR_HANDLER.Initialize;
6498: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
6499: END IF;
6500: ERROR_HANDLER.Add_Error_Message

Line 6504: ,p_message_type => FND_API.G_RET_STS_ERROR

6500: ERROR_HANDLER.Add_Error_Message
6501: (
6502: p_message_text => l_msg_text
6503: ,p_application_id => 'EGO'
6504: ,p_message_type => FND_API.G_RET_STS_ERROR
6505: ,p_row_identifier => p_inventory_item_id
6506: ,p_entity_id => p_entity_id
6507: ,p_entity_index => p_entity_index
6508: ,p_entity_code => p_entity_code

Line 6510: IF (FND_API.To_Boolean(p_init_error_handler)) THEN

6506: ,p_entity_id => p_entity_id
6507: ,p_entity_index => p_entity_index
6508: ,p_entity_code => p_entity_code
6509: );
6510: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
6511: ERROR_HANDLER.Log_Error
6512: (p_write_err_to_inttable => 'Y'
6513: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
6514: );

Line 6523: IF FND_API.To_Boolean(p_commit) THEN

6519: x_msg_count := l_msg_count;
6520: x_msg_data := l_msg_data;
6521: END IF; -- IF l_return_status <> 'S
6522:
6523: IF FND_API.To_Boolean(p_commit) THEN
6524: Debug_Msg('p_commit is TRUE, so commiting');
6525: COMMIT;
6526: END IF;
6527:

Line 6534: IF FND_API.To_Boolean(p_commit) THEN

6530: x_return_status := 'U';
6531: x_msg_count := 1;
6532: x_msg_data := SQLERRM;
6533: Debug_Msg('Unexpected Error in Process_UCCnet_Attrs_For_Item - '||x_msg_data);
6534: IF FND_API.To_Boolean(p_commit) THEN
6535: COMMIT;
6536: END IF;
6537: END Process_UCCnet_Attrs_For_Item;
6538: